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-04-2017

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

  • ora-25270 : sender info does not match with the actual sender of the message
  • ora-13871 : Invalid instance name
  • ora-30659 : too many locations specified for external table
  • ora-30452 : cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)
  • ora-29383 : all leaves of top-plan string must be consumer groups
  • ora-00325 : archived log for thread string, wrong thread # string in header
  • ora-10945 : trace name context forever
  • ora-22062 : invalid input string [string]
  • ora-01941 : SEQUENCE keyword expected
  • ora-38855 : cannot mark instance string (redo thread string) as enabled
  • ora-29707 : inconsistent value string for initialization parameter string with other instances
  • ora-18000 : invalid outline name
  • ora-13029 : Invalid SRID in the SDO_GEOMETRY object
  • ora-08206 : ora_addr: cannot translate address file name
  • ora-16626 : failed to enable specified object
  • ora-14117 : partition resides in offlined tablespace
  • ora-13826 : empty SQL profile not allowed for create or update SQL profile
  • ora-01224 : group number in header string does not match GROUP string
  • ora-27061 : waiting for async I/Os failed
  • ora-36221 : (XSLPDSC02) LIST number and LIST number have different base dimensions.
  • ora-39111 : Dependent object type string skipped, base object type string already exists
  • ora-29928 : duplicate default selectivity specified
  • ora-02315 : incorrect number of arguments for default constructor
  • ora-14629 : cannot drop the only subpartition of a partition
  • ora-00236 : snapshot operation disallowed: mounted control file is a backup
  • ora-31093 : null or invalid value specified for parameter : string
  • ora-16542 : unrecognized operation
  • ora-13340 : a point geometry has more than one coordinate
  • ora-02044 : transaction manager login denied: transaction in progress
  • ora-16586 : could not edit database property through instance
  • 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.