transporatable tablespace using datapump
Hello,
We are using transportable tablespace to recover a tablespace along with the contents as it was before dropping it.
We are doing this as follows:
-- At sys user:
exec dbms_tts.transport_set_check('NEW_SCOTT_TS',TRUE,TRUE);
select * from transport_set_violations; --Did not return any row
alter tablespace NEW_SCOTT_TS read only;
Then metadata is exported:
[oracle10@testserver ~]$ expdp scott/scott@testdb parfile=exp_tts_par_filear
Export: Release 10.2.0.1.0 - Production on Tuesday, 17 July, 2012 14:22:23
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prtion
With the Partitioning, OLAP and Data Mining options
We are doing this as follows:
-- At sys user:
exec dbms_tts.transport_set_check('NEW_SCOTT_TS',TRUE,TRUE);
select * from transport_set_violations; --Did not return any row
alter tablespace NEW_SCOTT_TS read only;
Then metadata is exported:
[oracle10@testserver ~]$ expdp scott/scott@testdb parfile=exp_tts_par_filear
Export: Release 10.2.0.1.0 - Production on Tuesday, 17 July, 2012 14:22:23
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prtion
With the Partitioning, OLAP and Data Mining options
0