Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Dropped table still has name in use

Dropped table still has name in use

From: anonymous <ouks5g202_at_sneakemail.com>
Date: Thu, 29 Apr 2004 13:46:51 -0700
Message-ID: <B_6dnV5UpLMh9AzdRVn-jg@speakeasy.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US