Re: Partitioned Table!

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Thu, 27 Apr 2006 10:27:12 +0200
Message-ID: <4450816e$0$11073$9b4e6d93@newsread4.arcor-online.net>

jsfromynr schrieb:
> Hello All,
>
> I am trying to find the key which is used to partition the tables given
> by following statement.
>
> Select table_name ,PARTITIONING_TYPE from all_part_tables;
>
> Is there any SQL statement which can help in this case??
>
> With Warm Regards
> Jatinder Singh
>

You can find columns composing partition keys in ALL_PART_KEY_COLUMNS

Best regards

Maxim Received on Thu Apr 27 2006 - 03:27:12 CDT