Re: How find default tablespace of partitioned tables?

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Mon, 29 May 2006 14:36:07 +0200
Message-ID: <447aec02$0$4501$9b4e6d93@newsread2.arcor-online.net>

schonlinner_at_yahoo.com schrieb:
> Hi,
>
> Database: Oracle 10.1.0.4
>
> How can I find out the default tablespace of a partitioned table?
> Querying user_tab_partitions I can find out on which tablespace each
> partition currently is.
>
> But there's a "default tablespace" for partitioned tables, which I can
> change after creating the table using the command:
>
> alter table xxx modify default attributes tablespace yyy
>
> How can I find out that default tablespace? I did not see any
> dictionary table which contains that information...
>
> Best regards,
> Alex
>

SELECT def_tablespace_name FROM dba(all,user)_part_tables

Best regards

Maxim Received on Mon May 29 2006 - 07:36:07 CDT