Re: 10g ASM

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 11 Apr 2006 11:33:03 -0700
Message-ID: <1144780383.377672.114770@z34g2000cwc.googlegroups.com>

> An ASM disk can be a partition.

Not in your life. ASM is a built-in Logical Volume Manager, what it does is physical disk space management. It has nothing to do with partitions (well, except for disk partitions, but these are completely different from table partitions.)

>after dropping table
>
>SQL> select object_type from dba_objects where object_name = 'xxx';
>
>
>shows :
>
>
>OBJECT_TYPE
>-------------------
>TABLE PARTITION
>TABLE PARTITION
>TABLE PARTITION
>...

How about querying for objects owned by the same user as the dropped table? Your query asks for objects named 'xxx' owned by *any* and all users in your database. It's pretty legal for different users to name their objects the same. Use correct predicates and/or correct views and you will see the truth. Eventually...

Hth,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Tue Apr 11 2006 - 13:33:03 CDT