ORA-00963 : unsupported interval type

Cause: An unsupported interval type was encountered.
Action: Use a valid interval type.

Popularity: 3% [?]


ORA-00962 : too many group-by / order-by expressions

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% [?]


ORA-00961 : bad datetime/interval value


Popularity: 1% [?]


ORA-00960: ambiguous column naming in select list

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% [?]


ORA-00959 : tablespace ’string’ does not exist

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% [?]


ORA-00958 : missing CHECK keyword

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% [?]


ORA-00957 : duplicate column name

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% [?]


ORA-00956 : missing or invalid auditing option

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% [?]


ORA-00955 : name is already used by an existing object

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% [?]


ORA-00954 : missing IDENTIFIED keyword

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% [?]


Close
E-mail It