If I create an interval partitioned table which can be spread across two tablespaces where can I see
Here is the DDL :-
create table jbh_part
(xml_document_seq number not null
, quote_timestamp date)
partition by range(quote_timestamp)
interval(numtoyminterval(1,'month'))
store in (users, crs)
(partition md1 values less than ('01-Jan-2009')
);
Where can I see the two tablespaces that it can use. I expected it to be in user_part_tables but here we see only one listed :-
select table_name, def_tablespace_name
from user_part_tables;
TABLE_NAME
--------------------------------------------------------------------------------
DEF_TABLESPACE_NAME
------------------------------
JBH_PART
USERS
user_tab_partitions only shows partitions that have already been created.
Thanks a lot,
John