Re: How to find out which partitions are defined

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sun, 15 Sep 2002 18:29:33 +1000
Message-ID: <goXg9.33069$g9.92768@newsfeeds.bigpond.com>

Hi Konstantinos,

Checkout DBA_TAB_PARTITIONS and DBA_TAB_SUBPARTITONS.

Checkout Oracle's Reference Manual for a full listing and description of all DD and V$ views.

Cheers

Richard
"Konstantinos Agouros" <elwood_at_agouros.de> wrote in message news:1032076789.454793_at_rumba...
> Hi,
>
> what's the easiest way to find out which partitions are set on a table and
> what their names are?
>
> Konstantin
> --
> Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood_at_agouros.de
> Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
> --------------------------------------------------------------------------
--
> "Captain, this ship will not survive the forming of the cosmos." B'Elana
Torres Received on Sun Sep 15 2002 - 03:29:33 CDT