ORA-29341: The transportable set is not self-contained

Cause : The set of objects in the set of tablespaces selected are not self-contained.

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

Consider using different export options, or removing some of the pointers that caused the violation, or selecting a different set of tablespaces.

update : 26-09-2017
ORA-29341

ORA-29341 - The transportable set is not self-contained
ORA-29341 - The transportable set is not self-contained

  • ora-06602 : LU6.2 Driver: Error allocating context area
  • ora-24850 : failed to startup shared subsystem
  • ora-07745 : slemcl: $CLOSE failure
  • ora-06262 : NETNTT: nfconn() failed
  • ora-26528 : local store callback proc phase failed for 'string.string'
  • ora-31697 : aborting operation at process order number string
  • ora-32016 : parameter "string" cannot be updated in SPFILE
  • ora-02310 : exceeded maximum number of allowable columns in table
  • ora-37143 : (XSSQLMDQ03) string is not a valid analytic workspace name.
  • ora-13136 : null common code generated
  • ora-12920 : database is already in force logging mode
  • ora-13511 : invalid INTERVAL string, must be in the range (string, string)
  • ora-39080 : failed to create queues "string" and "string" for Data Pump job
  • ora-19511 : Error received from media manager layer, error text: string
  • ora-22814 : attribute or element value is larger than specified in type
  • ora-23615 : Block number string does not exist for script string
  • ora-26064 : Invalid SCN specified - Wrap: string Base: string.
  • ora-04010 : the number of values to CACHE must be greater than 1
  • ora-24005 : must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables
  • ora-07253 : spdes: semctl error, unable to destroy semaphore set.
  • ora-01235 : END BACKUP failed for string file(s) and succeeded for string
  • ora-12053 : this is not a valid nested materialized view
  • ora-28041 : Authentication protocol internal error
  • ora-19257 : XQ0037 - function or variable string in module already defined
  • ora-40289 : duplicate attributes provided for data mining function
  • ora-07639 : smscre: SGA pad area not large enough (string bytes required)
  • ora-19926 : Database cannot be converted at this time
  • ora-12839 : cannot modify an object in parallel after modifying it
  • ora-23387 : replication parallel push dequeue error
  • ora-12485 : new effective label not within effective clearance
  • 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.