Re: 10g ASM

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 12 Apr 2006 21:45:43 -0700
Message-ID: <1144903540.765364@yasure.drizzle.com>

Vladimir M. Zakharychev wrote:
> "DA Morgan" <damorgan_at_psoug.org> wrote in message news:1144787015.662453_at_yasure.drizzle.com...

>>> SQL> select object_type  from dba_objects where object_name = 'xxx';
>>>
>>> shows :
>>>
>>> OBJECT_TYPE
>>> -------------------
>>> TABLE PARTITION
>>> TABLE PARTITION
>>> TABLE PARTITION
>>> ...
>>>
>>> Object type TABLE is dropped but not all "TABLE PARTITION"s
>> You have apparently been living in a cave or just ignoring everything
>> Oracle has published about 10g New Features. What it appears is that
>> you have objects in the RECYCLEBIN.
>>

>
> Tsk, tsk... Daniel, this is not correct. :) Dropped objects appear in
> RECYCLEBIN views (RECYCLEBIN, DBA_RECYCLEBIN,)
> but not in xxx_OBJECTS - after all, they are dropped... OP's
> query is simply incorrect (or OP's interpretation of the output,
> to be more precise.)
>
> Hth,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com

Don't tsk tsk me my friend. ;-)

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 12 21:43:17 2006

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> create table xyz (

2 testcol varchar2(20));

Table created.

SQL> drop table xyz;

Table dropped.

SQL> select object_name from user_objects;

OBJECT_NAME

BIN$l9+WbWJCSqW4SD9bAZrJvA==$0

Not in TAB$ but still in OBJ%. ;-)

Now I'll acknowlege I may be wrong here ... but the OP did not use the PURGE keyword so the object would still exist.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Wed Apr 12 2006 - 23:45:43 CDT