ORA-39123: Data Pump transportable tablespace job aborted;ORA-39185: The transportable tablespace failure list is ORA-29335: tablespace ‘EXAMPLE’ is not read only

ORA-39123: Data Pump transportable tablespace job aborted;ORA-39185: The transportable tablespace failure list is ORA-29335: tablespace ‘EXAMPLE’ is not read only

Cause:

29335, 00000, "tablespace '%s' is not read only"
// *Cause: The tablespace is not read only.
// *Action: Make the tablespace read only and retry the operation.

Transportable tablespace got failed during export due to read write tablespaces

Solution:

Check the tablespace for self containment without dependent data

SQL> exec dbms_tts.transport_set_check('EXAMPLE',true);

PL/SQL procedure successfully completed.

Make the tablespace readonly to maintain consistency of data

SQL> exec dbms_tts.transport_set_check('EXAMPLE',true);

PL/SQL procedure successfully completed.

Start the export

Starting "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01":  system/******** parfile=ttbs.par
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/STATISTICS/MARKER
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Master table "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TRANSPORTABLE_01 is:
  /tmp/ttbs.dmp
******************************************************************************
Datafiles required for transportable tablespace EXAMPLE:
  /app01/EXAMPLE12625.dbf
  /app01/EXAMPLE6345.dbf
  /app01/EXAMPLE7187.dbf
  /app01/oracle/product/base/oradata/orcl12x/example01.dbf
Job "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully completed at Wed Jan 13 16:22:24 2021 elapsed 0 00:00:14

Export is successful !

Leave a Reply

%d bloggers like this: