Re: 10g ASM

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 11 Apr 2006 13:23:37 -0700
Message-ID: <1144787015.662453@yasure.drizzle.com>

News wrote:

>> What does Automatic Storage Management which manages ASM Instance disk
>> groups and the dropping of a partitioned table in a database have to do
>> with each other?

>
> ASM is supposed to spread data across all disks in a disk group
> (striping). An ASM disk can be a partition.
>

>> How about displaying the SQL statements and results you are looking at
>> so someone can understand what you are really asking?

>
> after dropping table
>
> 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.

Try: DROP TABLE <table_name> PURGE;

Then go to Morgan's Library at www.psoug.org and look up RECYCLEBIN and TABLE FLASHBACK. No doubt you should also look up ORA_ROWSCN and many many other 10g features you've missed.

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

Received on Tue Apr 11 2006 - 15:23:37 CDT