Re: 10g ASM

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 13 Apr 2006 11:43:46 -0700
Message-ID: <1144953822.632081@yasure.drizzle.com>

Vladimir M. Zakharychev wrote:

> "DA Morgan" <damorgan_at_psoug.org> wrote in message news:1144903540.765364_at_yasure.drizzle.com...

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

> 
> Ok, I won't. Just couldn't resist. ;-D
> 

>> 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%. ;-)

> 
> Well, right, but if you query FROM %OBJECTS
> WHERE OBJECT_NAME='NAME_BEFORE_DROP'
> then you won't see these ghosts, that's what I meant.
> And OP's query did just that.

Well than I'll do it for you:

Should have read more closely Morgan. tsk tsk!

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

Received on Thu Apr 13 2006 - 13:43:46 CDT