Oracle Error ORA-00902
Further information: Although the reason for this is usually fairly obvious, if this is happening when the user is running a CREATE/ALTER TABLE statement that involves an Oracle7-style constraint definition, get the user to check the COMPATIBILITY setting. (Remember that SQL*Plus does a certain amount of preliminary syntax checking before passing the statement to the Server.) A common reason for this error is that the user has COMPATIBILITY set to V6. This may be because they have it set in the script they are running, have it set in glogin.sql or login.sql or they are running SQL*PLus 3.0 (which only runs in V6 - or V5! - compatibility mode). Try issuing: SQL> SET COMPAT V7 - and try the statement again. Note: If you get this when specifying a constraint in create table/alter table, make sure the word 'constraint' is followed by a constraint name (or remove it if using alter table) |