Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dropped table still has name in use
anonymous wrote:
> 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
>
>
>
Maybe post your create table statement, possible causes that spring to mind are that it is not the table name that is the problem, but a constraint or similar on your renamed table. Received on Fri Apr 30 2004 - 00:10:35 CDT