Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Partitioned table TTS export

Status
Not open for further replies.

Beantree

Programmer
Feb 27, 2001
95
US
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;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top