Re: How to find out which partitions are defined

Hi,

The data dictionary views USER_SEGMENTS and DBA_SEGMENTS can also be helpful. This advice does not replaces Richard's one, of course.

Wbr
Stan
On Sun, 15 Sep 2002 18:29:33 +1000, "Richard Foote" <richard.foote_at_bigpond.com> wrote:
> 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
>
>

--
Mgr. Stanislav Opichal
AGILITY s.r.o.
Kosmonautu 6
Olopmouc
772 31

e-mail: sopichal_at_agility-cz.com
tel: +420 68 5524312
gsm: +420 724 155073