Skip to Main Content
  • Questions
  • TTS unable to modify a file during IMPDP execution on 12c PDB

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Abhay.

Asked: April 10, 2017 - 1:31 pm UTC

Last updated: August 16, 2018 - 12:07 am UTC

Version: 12.1.0.2

Viewed 1000+ times

You Asked

Iwas trying to perfrom IMPDP tts for a set of tablespaces .While import other tablespaces are getting created but the IMPDP is failing in between when it is trying to read the below file and saying unable to modify .. My understanding is that the tablespaces details are already in read only mode before starting IMPDP . Help will be approeciated

ORA-39123: Data Pump transportable tablespace job aborted
ORA-00372: file 119 cannot be modified at this time
ORA-01110: data file 119: '/n01/oradata1/cdd0053/pdbd0053_1/o1_mf_people_w_5b7c5rqg_.dbf'

and Connor said...

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

ORA-00372: file 44 cannot be modified at this time

Jai, August 15, 2018 - 3:18 pm UTC

Our Database version 12.1 and we are migrating from HP UNIX to Linux. Using the XTTS methodology but while plugin the data files hitting the below error

Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Source time zone is +02:00 and target time zone is +00:00.
Starting "SYS"."SYS_IMPORT_FULL_01": /******** AS SYSDBA parfile=/acfs/ORCL/ORCLDIR/ORCL_imp_new.par
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK
ORA-39123: Data Pump transportable tablespace job aborted
ORA-00372: file 44 cannot be modified at this time
ORA-01110: data file 44: '/acfs1/ORCL/data_257_772992501'
Connor McDonald
August 16, 2018 - 12:07 am UTC

The most likely cause for that is a permissions issue at the OS level, because XTTS should not be impacted by the URL I referenced in the initial answer (because that was about sharing tablespaces between databases).

So make sure the files are read/write at OS level before attempting to plug them in.

If they definitely are read/write, then its time to talk to Support

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.