Hi,
Where does the tablespace name come from when you do a
~ select DBMS_METATDATA.GET_DDL('TABLE', 'tname', 'owner')...
on a table partitioned, where you see things like:
~ CREATE TABLE...
~ ...
~ STORAGE(INITIAL 134217728 NEXT 134217728 MINEXTENTS 1 MAXEXTENTS 2147483645
~ BUFFER_POOL DEFAULT)
~ TABLESPACE "ABCD_LOGD2"
before all the blocks related to the different partitions of this table, where a
~ select tablespace_name from dba_tables where table_name = 'TNAME'...
returns a null ??
Where does dbms_metatdata goes pick up this ABCD_LOGD2 value ?? (in which dictionary ?,
DBA_SEGMENTS/EXTENTS only show the partitions information...)
Thanks...
Seb