Thanks for the question, arjun.
Asked: November 17, 2016 - 9:54 pm UTC
Last updated: November 18, 2016 - 6:48 am UTC
Version: 12.1.0.2.0
Viewed 1000+ times
You Asked
We are trying to move the database from Solaris to Linux and are facing an issue with the self-contained tablespace.
Even after setting the execute sys.dbms_tts.transport_set_check('PSRBS',true); on a tablespace , get the below violation. How do we overcome this and export the tablespace.
We also tried to manually export and import into our Linux system but it throws the same error there.
[11/17/2016 4:01 PM] Parikshit Srivastava:
No Title
oracle12c@fsavbscr[AVBTEST] bin/sh $ expdp AVBBACKUP/a6bbackup dumpfile=psrbs.dmp transport_tablespaces=PSRBS transport_full_check=y
Export: Release 12.1.0.2.0 - Production on Thu Nov 17 15:29:31 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Starting "AVBBACKUP"."SYS_EXPORT_TRANSPORTABLE_01": AVBBACKUP/******** dumpfile=psrbs.dmp transport_tablespaces=PSRBS transport_full_check=y
ORA-39123: Data Pump transportable tablespace job aborted
ORA-39187: The transportable set is not self-contained, violation list is
ORA-39920: Rollback segment R01 in tablespace PSRBS not allowed in transportable set.
ORA-39920: Rollback segment R02 in tablespace PSRBS not allowed in transportable set.
ORA-39920: Rollback segment R03 in tablespace PSRBS not allowed in transportable set.
ORA-39920: Rollback segment R04 in tablespace PSRBS not allowed in transportable set.
ORA-39920: Rollback segment RBSBIG in tablespace PSRBS not allowed in transportable set.
Job "AVBBACKUP"."SYS_EXPORT_TRANSPORTABLE_01" stopped due to fatal error at Thu Nov 17 15:31:41 2016 elapsed 0 00:02:06
SQL> select * from sys.transport_set_violations;
VIOLATIONS
--------------------------------------------------------------------------------
ORA-39920: Rollback segment RBSBIG in tablespace PSRBS not allowed in transporta
ble set.
ORA-39920: Rollback segment R04 in tablespace PSRBS not allowed in transportable
set.
ORA-39920: Rollback segment R03 in tablespace PSRBS not allowed in transportable
set.
ORA-39920: Rollback segment R02 in tablespace PSRBS not allowed in transportable
set.
VIOLATIONS
--------------------------------------------------------------------------------
ORA-39920: Rollback segment R01 in tablespace PSRBS not allowed in transportable
set.
and Connor said...
That looks like an undo tablespace. You dont need to transport that a new database, because the new database will *already* have an undo tablespace.
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment