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

Home -> Community -> Usenet -> c.d.o.server -> Transportable tablespaces within the same database

Transportable tablespaces within the same database

From: <jms.news_at_gmail.com>
Date: Fri, 08 Jun 2007 05:00:17 -0000
Message-ID: <1181278817.166749.65340@i13g2000prf.googlegroups.com>


Instead of transporting a tablespace between 2 databases .... can one transport the tablespace to the same database to essentially "restore" a tablespace to the state when the datafiles were copied ?

e.g.: Assuming I have only one user that owns objects in the tablespace(s):

  1. alter tablespace ts1 read_only; alter tablespace ts2 read_only;
  2. EXP TRANSPORT_TABLESPACE=y TABLESPACES=(ts1,ts2) TRIGGERS=y CONSTRAINTS=n GRANTS=n FILE=tsexpdat.dmp
  3. Copy the datafiles of tablespaces ts1 and ts2 to a different location.
  4. Drop all objects owned by user
  5. IMP TRANSPORT_TABLESPACE=y FILE=tsexpdat.dmp DATAFILES=('/db/datafile1,'/db/datafile2') TABLESPACES=(ts1,ts2) TTS_OWNERS=(joe)
  6. ALTER TABLESPACE ts1 READ WRITE ALTER TABLESPACE ts2 READ WRITE
Received on Fri Jun 08 2007 - 00:00:17 CDT

Original text of this message

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