Look at dba_tab_partitions, dba_ind_partitions
Similar for sub partitions.
--
Jonathan Lewis
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html
For latest news of public appearances
See http://www.jlcomp.demon.co.uk
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
Thomas Kirchner wrote in message <1103_998474937_at_r308-tki>...
>Hello folks,
>
>I'm looking for a way to detect the partitions of a table in my database.
>The number of partitions in my database may vary.
>But to do some checks automatically I need the name of the exisiting
partitions for my tables via some kind of select.
>
>Has anyone done this?
>
>Thanx
>
>
Received on Wed Aug 22 2001 - 05:34:24 CDT
