ORA-00947 not enough values What causes an ORA-00947 error? This error occurs when a SQL statement requires two sets of values equal in number, but the second set contains fewer … Read more
ORA-00950 invalid DROP option What causes an ORA-00950 error? A DROP command was not followed by a valid DROP option, such as CLUSTER, DATABASE LINK, INDEX, ROLLBACK SEGMENT, SEQUENCE, SYNONYM, … Read more
ORA-00955 name is already used by an existing object What causes an ORA-00955 error? An attempt was made to create a database object (such as a table, view, cluster, index, … Read more
ORA-00957 duplicate column name What causes an ORA-00957 error? A column name was specified twice in a CREATE or INSERT statement. Column names must be unique within a table, view, … Read more
ORA-00922 missing or invalid option What causes an ORA-00922 error? An invalid option was specified in defining a column or storage clause. The valid option in specifying a column is … Read more
ORA-00960 ambiguous column naming in select list What causes an ORA-00960 error? A column name in the order-by list matches more than one select list columns. How Xynomix can help … Read more
ORA-00923 FROM keyword not found where expected What causes an ORA-00923 error? In a SELECT or REVOKE statement, the keyword FROM was either missing, misplaced, or misspelled. The keyword FROM … Read more
ORA-00969 missing ON keyword What causes an ORA-00969 error? The keyword ON in a GRANT, REVOKE, or CREATE INDEX statement was missing, misspelled, or misplaced. How Xynomix can help Check … Read more
ORA-01427 single-row subquery returns more than one row What causes an ORA-01427 error? The outer query must use one of the keywords ANY, ALL, IN, or NOT IN to specify … Read more
ORA-00972 identifier is too long What causes an ORA-00972 error? The name of a schema object exceeds 30 characters. Schema objects are tables, clusters, views, indexes, synonyms, tablespaces, and usernames. … Read more
