Error List

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

ORA-01435 user does not exist

Description:
ORA-01435 user does not exist

Cause:
This message is caused by any reference to a non-existent user. For example, it occurs if a SELECT, GRANT, or REVOKE statement specifies a username that does not exist. Only a GRANT CONNECT statement may specify a new username. All other GRANT and REVOKE statements must specify existing usernames. If specified in a SELECT statement, usernames must already exist.

admin ORA-00900 to ORA-01499

ORA-01436 CONNECT BY loop in user data

Description:
ORA-01436 CONNECT BY loop in user data

Cause:
The condition specified in a CONNECT BY clause caused a loop in the query, where the next record to be selected is a descendent of itself. When this happens, there can be no end to the query.

admin ORA-00900 to ORA-01499

ORA-01437 cannot have join with CONNECT BY

Description:
ORA-01437 cannot have join with CONNECT BY

Cause:
A join operation was specified with a CONNECT BY clause. If a CONNECT BY clause is used in a SELECT statement for a tree-structured query, only one table may be referenced in the query.

admin ORA-00900 to ORA-01499

ORA-01438 value larger than specified precision allows for this column

Description:
ORA-01438 value larger than specified precision allows for this column

Cause:
When inserting or updating records, a numeric value was entered that exceeded the precision defined for the column.

admin ORA-00900 to ORA-01499

ORA-01439 column to be modified must be empty to change datatype

Description:
ORA-01439 column to be modified must be empty to change datatype

Cause:
An ALTER TABLE MODIFY statement attempted to change the datatype of a column containing data. A column whose datatype is to be altered must contain only NULL values.

admin ORA-00900 to ORA-01499

ORA-01440 column to be modified must be empty to decrease precision or scale

Description:
ORA-01440 column to be modified must be empty to decrease precision or scale

Cause:
An ALTER TABLE MODIFY statement attempted to decrease the scale or precision of a numeric column containing data. In order to decrease either of these values, the column must contain only NULL values. An attempt to increase the scale without also increasing the precision will also cause this message.

admin ORA-00900 to ORA-01499

ORA-01441 cannot decrease column length because some value is too big

Description:
ORA-01441 cannot decrease column length because some value is too big

Cause:
An ALTER TABLE MODIFY statement attempted to decrease the size of a character field containing data. A column whose maximum size is to be decreased must contain only NULL values.

admin ORA-00900 to ORA-01499

ORA-01442 column to be modified to NOT NULL is already NOT NULL

Description:
ORA-01442 column to be modified to NOT NULL is already NOT NULL

Cause:
An ALTER TABLE MODIFY statement attempted to change a column specification unnecessarily, from NOT NULL to NOT NULL.

admin ORA-00900 to ORA-01499

ORA-01443 internal inconsistency; illegal datatype in resultant view column

Description:
ORA-01443 internal inconsistency; illegal datatype in resultant view column

Cause:
An internal error occurred in referencing a view.

admin ORA-00900 to ORA-01499

ORA-01444 internal inconsistency; internal datatype maps to invalid external type

Description:
ORA-01444 internal inconsistency; internal datatype maps to invalid external type

Cause:
This is an internal error message not normally issued.

admin ORA-00900 to ORA-01499