Hi,
I wanted to convert a column (e.g. column_1) of type BLOB to CLOB (it did not have any data) so I dropped the column and recreated it using following command:
SQL> alter table table_1 add column_1 clob default empty_clob() not null;
I am getting following error:
ORA-00955: name is already used by an existing object
Please let me know how to fix this error.
