Re: Object names changed to BIN$pgkQ... etc

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 06 Nov 2007 10:27:05 -0800
Message-ID: <1194373622.38478@bubbleator.drizzle.com>

Helma wrote:

>>> Ok, last question to you: why are suddenly almost all my tables moved
>>> to the recyclebin? I will have to look on your site to find the
>>> answer.

>
>

>> There is only one thing that moves tables to the recyclebin:
>>
>> DROP TABLE <table_name>;
>> Takes the indexes and constraints supported by indexes there too.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org

>
> As stated, I didn't issue a drop table command. Strange that they
> appear in both the recyclebin AND in user_tables. The time of the last
> DDL on the tables dates from a few days ago, when i created them.
> Yesterday it looked ok there was no problem, but i noticed the entries
> in the recyclebin today.
>
> I think i'll use the windows solution: drop and recreate, and apply
> patches first.
>
> Thank you all very much for your help,
> HV.

Nothing can exist in both the recyclebin and user_tables. What you are seeing is understandable though if your approach to Oracle is to stumble around rather than read the docs.

Create a table named test: Drop it.
Create another table named test: Drop it. Create a third table named test: Drop it.

SELECT object_name, original_name
FROM recyclebin;

To understand what is happening ... read the docs and work your way through the demos in my library. A usenet group is not a substitute for a one hour class.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Nov 06 2007 - 12:27:05 CST