Database DataWarehousing (MOSC)

MOSC Banner

SQL to list tablespaces for partitioned index only table?

edited Jan 21, 2010 9:59PM in Database DataWarehousing (MOSC) 4 commentsAnswered ✓
 I am trying to write some sql to get a list of partitions and accociated tablespaces for a given table.

For normal tables I use the following sql:

    select table_name, partition_name, tablespace_name
      from user_tab_partitions

However this does not work for Index Only Tables. Reviewing the details of user_tab_partitions, it expressly returns null for the tablespace_name for IOTs.

Can anyone suggest how I might get a list of partitions and tablespaces for my index only tables?

I am using Oracle 9i on Solaris.

Thanks

Paul Graves

paul.graves@eds.com

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center