Re: How do I view what partition names are?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 17 Jan 2005 20:42:54 +0100
Message-ID: <41ec1532$0$18268$626a14ce@news.free.fr>

"RK" <rekaben_at_yahoo.com> a écrit dans le message de news:239f1935.0501171119.40a914a1_at_posting.google.com...
| Hi,
|
| I am not the DBA, and I can not find him anywhere. But I know the big
| tables are partitioned. My question is that how to find out what the
| partition names the DBA is using for partitioning the tables.
| Something like the following codes to find what tablenames are:
|
| select table_name from all_tables;
|
| Which table can I look for this info? Any help?
|
| Thanks.
|
| RK

all_part_tables
all_tab_partitions

You'll find all documentations at http://tahiti.oracle.com/

Regards
Michel Cadot Received on Mon Jan 17 2005 - 13:42:54 CST