Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Exporting a partition with transport tablespace

RE: Exporting a partition with transport tablespace

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Mon, 22 Dec 2003 12:49:24 -0800
Message-ID: <F001.005DAA7F.20031222124924@fatcity.com>









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.

 

Igor Neyman, OCP DBA

ineyman@perceptron.com

 

 

-----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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

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 - 14:49:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US