| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Exporting a partition with transport tablespace
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 : ml-errors@fatcity.com [mailto:ml-errors@fatcity.com]De la part de
ryan_oracle@cox.net
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)" <philippe.nguyen@cetelem.fr>
> Date: 2003/12/22 Mon AM 10:34:25 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
> 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
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: NGUYEN Philippe (Cetelem) INET: philippe.nguyen_at_cetelem.fr Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Dec 22 2003 - 12:59:27 CST
 |
 |