ORA-39123: Data Pump transportable tablespace job aborted string

Cause : A DBMS_PLUGTS procedure failed and the Data Pump operation could not continue so it was aborted. The DBMS_PLUGTS failure listed describes the original error.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Look at the DBMS_PLUGTS error to determine actual cause.

update : 16-08-2017
ORA-39123

ORA-39123 - Data Pump transportable tablespace job aborted string
ORA-39123 - Data Pump transportable tablespace job aborted string

  • ora-19551 : device is busy, device type: string, device name: string
  • ora-25508 : database is not mounted
  • ora-24182 : attribute number specified does not exist
  • ora-29887 : cannot support row movement if domain index defined on table
  • ora-02464 : Cluster definition can not be both HASH and INDEX
  • ora-28238 : no seed provided
  • ora-09939 : Restoration of signal handlers failed.
  • ora-30114 : error when processing from command line
  • ora-12991 : column is referenced in a multi-column constraint
  • ora-19279 : XQuery dynamic type mismatch: expected singleton sequence - got multi-item sequence
  • ora-32317 : cannot run a job from a job
  • ora-12073 : request cannot be processed
  • ora-33458 : (ESDREAD09) Discarding compiled code for workspace object because number is now type string, whereas it was type string when the code was compiled.
  • ora-28526 : invalid describe information returned to Heterogeneous Services
  • ora-14452 : attempt to create, alter or drop an index on temporary table already in use
  • ora-31060 : Resource at path string could not be deleted
  • ora-13291 : conversion error between the specified unit and standard unit
  • ora-32405 : cannot alter tablespace for existing materialized view log
  • ora-14279 : index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-31111 : table string cannot be hierarchically enabled
  • ora-01625 : rollback segment 'string' does not belong to this instance
  • ora-00127 : dispatcher string does not exist
  • ora-02235 : this table logs changes to another table already
  • ora-02052 : remote transaction failure at string
  • ora-32591 : connect string too long
  • ora-01868 : the leading precision of the interval is too small
  • ora-19508 : failed to delete file "string"
  • ora-03008 : parameter COMPATIBLE >= string needed for string
  • ora-12226 : TNS:operating system resource quota exceeded
  • ora-31507 : %s parameter value longer than maximum length string
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.