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 -> Re: Transportable tablespaces within the same database

Re: Transportable tablespaces within the same database

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Fri, 8 Jun 2007 13:12:35 +0200
Message-ID: <4669399b$0$79139$e4fe514c@news.xs4all.nl>

<jms.news_at_gmail.com> schreef in bericht news:1181278817.166749.65340_at_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
>

Yes one can! Received on Fri Jun 08 2007 - 06:12:35 CDT

Original text of this message

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