Yes, my partitions are in separate tablespaces
so do I have to export all the tablespaces concerned ?
wich solution do you use ? each partition is over 8 Go so should I use common export command to backup only one tablespace ?
-----Message d'origine-----
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]De la part de
[EMAIL PROTECTED]
Envoyé : lundi 22 décembre 2003 17:09
À : Multiple recipients of list ORACLE-L
Objet : Re: Exporting a partition with transport tablespace
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
>
>
