Oracle8 Error Messages Release 8.0.4 A58312-01 |
Library | Product | Contents | Index

## 02420-02429: Schema Messages

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

Cause: Either:

- 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.

Action: If the cause is

- 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.

Action: See Oracle8 Server SQL Reference for the valid elements of the 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.

Prev | Top | Next
| Copyright © 1997 Oracle Corporation. All Rights Reserved. |
Library | Product | Contents | Index