ORA-00963 : unsupported interval type
Cause: An unsupported interval type was encountered.
Action: Use a valid interval type.
Popularity: 3% [?]
Complete Source for Oracle Error Code Ora-, Pl/Sql Tips and Tricks and Oracle Error Message Description
Cause: An unsupported interval type was encountered.
Action: Use a valid interval type.
Popularity: 3% [?]
Cause: The group-by or order-by column list contain more than 1000 expressions.
Action: Use 1000 or less expressions in the group-by or order-by list.
Popularity: 2% [?]
Cause : A column name in the order-by list matches more than one select list columns.
Action : Remove duplicate column naming in select list.
Popularity: 2% [?]
Cause : A statement specified the name of a tablespace that does not exist.
Action : Enter the name of an existing tablespace. For a list of tablespace names, query the data dictionary.
Popularity: 3% [?]
Cause : The keyword CHECK should follow the keyword WITH in the WITH OPTION clause of the CREATE VIEW statement.
Action : Check the statement syntax and insert the keyword CHECK where required. Then retry the statement.
Popularity: 2% [?]
Cause : A column name was specified twice in a CREATE or INSERT statement.
Column names must be unique within a table, view, or cluster.
Action : In a CREATE statement, change one of the column names to a new, unique column name. In an INSERT statement, remove one of the duplicate names.
Popularity: 2% [?]
Cause : An AUDIT or NOAUDIT command was not followed by a valid option or the keyword ALL. For example, when AUDITing tables an option such as ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK,
RENAME, SELECT, or UPDATE must be specified.
Action : Correct the syntax.
Popularity: 3% [?]
Cause : An attempt was made to create a database object (such as a table, view,cluster, index, or synonym) that already exists. A user’s database objects must have distinct names.
Action : Enter a unique name for the database object or modify or drop the existing object so it can be reused.
Popularity: 2% [?]
Cause : A GRANT CONNECT statement was issued without the keyword IDENTIFIED.
Action : Check the syntax and insert the keyword IDENTIFIED after the last username. The format is
GRANT CONNECT TO user-list IDENTIFIED BY password-list;
Popularity: 3% [?]