Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Transportable tablespaces within the same database
<jms.news_at_gmail.com> a écrit dans le message de 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
|
And the purpose is?
Regards
Michel Cadot
Received on Fri Jun 08 2007 - 10:37:09 CDT