Database Administration (MOSC)

MOSC Banner

If I create an interval partitioned table which can be spread across two tablespaces where can I see

edited May 16, 2018 11:47AM in Database Administration (MOSC) 8 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center