Re: 10g ASM

From: News <Contact_404_at_hotmail.com>
Date: 11 Apr 2006 10:06:44 -0700
Message-ID: <1144775204.411225.157810@j33g2000cwa.googlegroups.com>

> 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 Received on Tue Apr 11 2006 - 12:06:44 CDT