Re: Exporting a partition with transport tablespace

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Sat, 27 Dec 2003 12:59:25 -0800
Message-ID: <F001.005DB217.20031227125925@fatcity.com>

Exporting a partition with transport tablespace

Make sure that you use novalidate and exchange indexes as well - that way Oracle won't make unnecessary work.

Also, you should export the metadata at the time when required partitions are exchanged to "transport tables".

Tanel.

----- Original Message -----

From: Igor Neyman

To: Multiple recipients of list ORACLE-L

Sent: Monday, December 22, 2003 10:49 PM

Subject: 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.

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: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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 Sat Dec 27 2003 - 14:59:25 CST