Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Dropped table still has name in use
I used the TOAD feature of "Rebuild Table" on a table I am experimenting
with (no important data in it). It renamed the table to table_x ok, copied
the data to it, dropped the original table, then when it went to re-create
the table, it gave ORA-00955: name is aready used by an existing object. At
the time, I was also testing an alter schema DDL trigger which had problems,
so it's possible this had some interaction (I've since dropped the trigger).
A select from all_objects and even sys.obj$ looking for the table name, returns nothing. But trying to create even a dummy table using that name gives the error.
Any ideas? TIA. Oh, Oracle 9.2.0.1 Received on Thu Apr 29 2004 - 15:46:51 CDT