Re: Query for active tablespaces

From: Jagjeet Singh <jagjeet.malhi_at_gmail.com>
Date: Wed, 10 Oct 2007 15:02:19 -0000
Message-ID: <1192028539.454116.302180@d55g2000hsg.googlegroups.com>

I have not tested this but it seems this will not return the result partitioned tables/indexes

First - You are joining dba_Segment.segment_Type = v$access.type. For partitioned tables/indexes

dba_Segment.segment_Type is "TABLE PARTITIONED" ....

Second - Even if you fix this in join like "segment_Type like v $access.type%.." but still it would

give you all the tablespaces where your partition are lying because in v$access table

it would show you just Segment_name not directly partition name

like the query "Delete from Tab_X Partition (p1)" would be actually accessing the tablespace

where it is lying but it would show you all the partitions tablespaces.

Regards,
Jagjeet Singh Received on Wed Oct 10 2007 - 10:02:19 CDT