Discussion Locked

Oracle Error ORA-00955

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

4 replies

by ckeruhi

Note: I have checked in table user_objects and there is no object of name 'column_1'.

by jay eckles

Hate to suggest the obvious, but did you "commit" after you dropped the column? An alternative method to convert the column might be to copy the table to a temporary table, drop the original table, then create a new table with the correct column names and formats, copy the data from the temp table to the new table, then drop the temp table. This is how PeopleSoft alters tables sometimes when it's connected to Oracle.

by ckeruhi

Thanks for the suggestion. As for the "commit", I think all DDL (Data definition) statements are "Auto committed"
to Database.

This discussion is closed to new replies.