Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to get the partitions used by a table?
Hi
dba_tab_partitions, dba_ind_partitions and so on
pete finnigan
www.pentest-limited.com
In article <1103_998474937_at_r308-tki>, Thomas Kirchner
<thomas.kirchner_at_she.net> writes
>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
>
>
-- Pete Finnigan IT Security Consultant PenTest Limited Office 01565 830 990 Fax 01565 830 889 Mobile 07974 087 885 pete.finnigan_at_pentest-limited.com www.pentest-limited.comReceived on Fri Aug 24 2001 - 13:05:15 CDT