Monday, May 26, 2014

ORA-12983: cannot drop all columns in a table

Cause :- When you want to drop all column from a table you get this error. Table must remain at least one or more column.

SQL> CREATE TABLE TEST_COLUMN(ID NUMBER);

Table created.

SQL>
SQL> ALTER TABLE TEST_COLUMN DROP COLUMN ID;
ALTER TABLE TEST_COLUMN DROP COLUMN ID
*
ERROR at line 1:
ORA-12983: cannot drop all columns in a table


SQL>

No comments:

Post a Comment