I have a partitioned table that is defined as being in a tablespace, but composed of partitions in other tablespaces.
How can I export it using Transportable tablespaces?
Script follows.
CREATE TABLE T_CUSTOMER_TA_ARC
(
ACCOUNT_NUMBER VARCHAR2(8) NOT NULL,
TA_NUMBER NUMBER(5) NOT NULL,
EQUITY_PCT NUMBER(7,3),
MKT_VALUE NUMBER(25,2),
SETT_DATE_BAL NUMBER(25,2),
TRADE_DATE_BAL NUMBER(25,2),
LAST_MODIFIED DATE,
ORIGINAL_EQUITY_PCT NUMBER(7,3),
ORIGINAL_MKT_VALUE NUMBER(25,2),
ORIGINAL_SETT_DATE_BAL NUMBER(25,2),
ORIGINAL_TRADE_DATE_BAL NUMBER(25,2),
ID NUMBER NOT NULL,
TIMESTAMP DATE
)
TABLESPACE FM
NOLOGGING
PARTITION BY RANGE (TIMESTAMP)
(
PARTITION TA_2001 VALUES LESS THAN (TO_DATE(' 2002-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
NOLOGGING
TABLESPACE POD_NTTA_ARC_P1
,
PARTITION TA_2002 VALUES LESS THAN (TO_DATE(' 2003-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
NOLOGGING
TABLESPACE POD_NTTA_ARC_P2
,
PARTITION TA_2003 VALUES LESS THAN (TO_DATE(' 2004-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
NOLOGGING
TABLESPACE POD_NTTA_ARC_P3
,
PARTITION TA_2004 VALUES LESS THAN (TO_DATE(' 2005-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
LOGGING
TABLESPACE POD_NTTA_ARC_P4
)
NOCACHE
NOPARALLEL;
How can I export it using Transportable tablespaces?
Script follows.
CREATE TABLE T_CUSTOMER_TA_ARC
(
ACCOUNT_NUMBER VARCHAR2(8) NOT NULL,
TA_NUMBER NUMBER(5) NOT NULL,
EQUITY_PCT NUMBER(7,3),
MKT_VALUE NUMBER(25,2),
SETT_DATE_BAL NUMBER(25,2),
TRADE_DATE_BAL NUMBER(25,2),
LAST_MODIFIED DATE,
ORIGINAL_EQUITY_PCT NUMBER(7,3),
ORIGINAL_MKT_VALUE NUMBER(25,2),
ORIGINAL_SETT_DATE_BAL NUMBER(25,2),
ORIGINAL_TRADE_DATE_BAL NUMBER(25,2),
ID NUMBER NOT NULL,
TIMESTAMP DATE
)
TABLESPACE FM
NOLOGGING
PARTITION BY RANGE (TIMESTAMP)
(
PARTITION TA_2001 VALUES LESS THAN (TO_DATE(' 2002-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
NOLOGGING
TABLESPACE POD_NTTA_ARC_P1
,
PARTITION TA_2002 VALUES LESS THAN (TO_DATE(' 2003-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
NOLOGGING
TABLESPACE POD_NTTA_ARC_P2
,
PARTITION TA_2003 VALUES LESS THAN (TO_DATE(' 2004-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
NOLOGGING
TABLESPACE POD_NTTA_ARC_P3
,
PARTITION TA_2004 VALUES LESS THAN (TO_DATE(' 2005-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
LOGGING
TABLESPACE POD_NTTA_ARC_P4
)
NOCACHE
NOPARALLEL;