RE: Exporting a partition with transport tablespace

You could create new table in transportable tablespace, exchange data with the partition you want to export, move transportable tablespace file to the destination system, exchange data back from the table into desired partition.

-----Original Message-----
From: ml-errors@fatcity.com [mailto:ml-errors@fatcity.com] On Behalf Of NGUYEN Philippe (Cetelem)
Sent: Monday, December 22, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L
Subject: Exporting a partition with transport tablespace

Hi list,
is it possible to export a partition with the transportable tablespace feature ?
My partition is over 8 Go.

Here my statements , thank you in advance !

SQL>exec sys.dbms_tts.transport_set_check('HISTO_DOSSIER_P1_MD_TAB',FALSE);
SQL> select * from sys.transport_set_violations;

VIOLATIONS
--------------------------------------------------------------------------------
Partitioned table TOPASE.HISTO_DOSSIER is partially contained in the transportab
le set: check table partitions by querying sys.dba_tab_partitions

Default Partition (Table) Tablespace HISTO_DOSSIER_P2_MD_TAB for HISTO_DOSSIER n
ot contained in transportable set

Default Partition (Table) Tablespace HISTO_DOSSIER_P3_MD_TAB for HISTO_DOSSIER n
ot contained in transportable set

Default Partition (Table) Tablespace HISTO_DOSSIER_P4_MD_TAB for HISTO_DOSSIER n
ot contained in transportable set