Error List

Error List for the ‘ORA-00900 to ORA-01499’ Category

ORA-01445 cannot select ROWID from a join view without a key-preserved table

Description:
ORA-01445 cannot select ROWID from a join view without a key-preserved table

Cause:
A SELECT statement attempted to select ROWIDs from a view derived from a join operation. Because the rows selected in the view do not correspond to underlying physical records, no ROWIDs can be returned.

ORA-00900 to ORA-01499 , , , , , , ,

ORA-01446 cannot select ROWID from view with DISTINCT, GROUP BY, etc.

ORA-01447 ALTER TABLE does not operate on clustered columns

Description:
ORA-01447 ALTER TABLE does not operate on clustered columns

Cause:
An ALTER TABLE MODIFY statement specified a column used to cluster the table. Clustered columns may not be altered.

ORA-00900 to ORA-01499 , , , ,

ORA-01448 index must be dropped before changing to desired type

Description:
ORA-01448 index must be dropped before changing to desired type

Cause:
An ALTER TABLE MODIFY statement attempted to change an indexed character column to a LONG column. Columns with the datatype LONG may not be indexed, so the index must be dropped before the modification.

ORA-00900 to ORA-01499

ORA-01449 column contains NULL values; cannot alter to NOT NULL

Description:
ORA-01449 column contains NULL values; cannot alter to NOT NULL

Cause:
An ALTER TABLE MODIFY statement attempted to change the definition of a column containing NULL values to NOT NULL. The column may not currently contain any NULL values if it is to be altered to NOT NULL.

ORA-00900 to ORA-01499 , , , , ,

ORA-01450 maximum key length (string) exceeded

Description:
ORA-01450 maximum key length (string) exceeded

Cause:
The combined length of all the columns specified in a CREATE INDEX statement exceeded the maximum index length. The maximum index length varies by operating system. The total index length is computed as the sum of the width of all indexed columns plus the number of indexed columns. Date fields have a length of 7, character fields have their defined length, and numeric fields have a length of 22. Numeric length = (precision/2) + 1. If negative, add +1.

ORA-00900 to ORA-01499 , ,

ORA-01451 column to be modified to NULL cannot be modified to NULL

Description:
ORA-01451 column to be modified to NULL cannot be modified to NULL

Cause:
The column may already allow NULL values, the NOT NULL constraint is part of a primary key or check constraint, or an ALTER TABLE MODIFY statement attempted to change a column specification unnecessarily, from NULL to NULL.

ORA-00900 to ORA-01499 ,

ORA-01452 cannot CREATE UNIQUE INDEX; duplicate keys found

ORA-01453 SET TRANSACTION must be first statement of transaction

Description:
ORA-01453 SET TRANSACTION must be first statement of transaction

Cause:
A transaction was not processed properly because the SET TRANSACTION statement was not the first statement.

ORA-00900 to ORA-01499 ,

ORA-01454 cannot convert column into numeric datatype

Description:
ORA-01454 cannot convert column into numeric datatype

Cause:
A non-numeric value could not be converted into a number value.

ORA-00900 to ORA-01499