transportable tablespaces need to be totally self-contained. everything that is being transported has to be in that tablespace. it doesnt matter if its a different datafile.
you probably have your partitions in seperate tablespaces? or am i wrong?
>
> From: "NGUYEN Philippe (Cetelem)" <[EMAIL PROTECTED]>
> Date: 2003/12/22 Mon AM 10:34:25 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> 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
>
>
Title: 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
