Oracle7 Server Messages
02420-02429: Schemas
This section lists messages generated when commands are used that alter schemas or schema objects.
ORA-02420 missing schema authorization clause
Cause: | The schema AUTHORIZATION clause is missing in a CREATE SCHEMA statement. | |
Action: | Check the syntax of the statement, provide a valid schema AUTHORIZATION clause, and retry the statement. | |
ORA-02421 missing or invalid schema authorization identifier
- The schema authorization identifier is not recognized.
- An attempt was made to use a schema authorization identifier for a user while not connected as that user.
- an unrecognized identifier, then use an existing identifier.
- connected with a different user name, then disconnect and connect to the correct user name.
ORA-02422 missing or invalid schema element
Cause: | A statement other than a CREATE TABLE, CREATE VIEW, or GRANT appears in a CREATE SCHEMA statement. | |
ORA-02423 schema name does not match schema authorization identifier
Cause: | A table definition with a schema name prepended to the table name does not match the schema name provided in the AUTHORIZATION clause of a CREATE SCHEMA STATEMENT. | |
Action: | Check that the schema names match the one given in the CREATE
SCHEMA statement. | |
ORA-02424 potential circular view references or unknown referenced tables
Cause: | The CREATE SCHEMA statement contains a view that depends on other views contained in the CREATE SCHEMA statement, or they contain references to non-existing tables. | |
Action: | Create the dependent views in a separate CREATE SCHEMA statement and ensure that all referenced tables are either defined in the CREATE SCHEMA statement or exist outside the statement. | |
ORA-02425 create table failed
Cause: | A CREATE TABLE statement failed in the CREATE SCHEMA statement. | |
Action: | The cause for failure will be presented below this message. Follow the appropriate actions as suggested by the subsequent messages. | |
ORA-02426 privilege grant failed
Cause: | A GRANT statement failed in the CREATE SCHEMA statement. | |
Action: | The cause for failure will be presented below this message. Follow appropriate actions, as suggested by the subsequent messages. | |
ORA-02427 create view failed
Cause: | A CREATE VIEW statement failed in the CREATE SCHEMA statement. | |
Action: | The cause for failure will be presented below this message. Follow appropriate actions, as suggested by the subsequent messages. | |
ORA-02428 could not add foreign key reference
Cause: | Oracle could not add a foreign key reference because of an error in the declaration. Either the referenced table does not exist or the table does not have a unique key. | |
Action: | Check that the referenced table exists and/or has a unique key. | |
ORA-02429 cannot drop index used for enforcement of unique/primary key
Cause: | An attempt was made to drop an index that is being used as the enforcement mechanism for a unique or primary key. | |
Action: | Drop the integrity constraint instead of dropping the index. | |