Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to get the partitions used by a table?

Re: How to get the partitions used by a table?

From: Pete Finnigan <pete_at_peterfinnigan.demon.co.uk>
Date: Fri, 24 Aug 2001 19:05:15 +0100
Message-ID: <XWSQdsAbdph7EwvA@peterfinnigan.demon.co.uk>


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.com
Received on Fri Aug 24 2001 - 13:05:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US