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 : 23-07-2017

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

  • ora-36342 : (SNSYN200) The format of the CLEAR command is: CLEAR [ ALL | STATUS ] [ AGGREGATES | CHANGES | PRECOMPUTES | NONPRECOMPUTES | CACHE ] FROM var1 [var2, var3...] [USING aggmap]
  • ora-22903 : MULTISET expression not allowed
  • ora-14096 : tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns
  • ora-16030 : session specific change requires a LOG_ARCHIVE_DEST_n destination
  • ora-23470 : invalid status
  • ora-23495 : serial propagation can not be used for "string"
  • ora-24302 : host connection in use by another thread
  • ora-19032 : Expected XML tag string got string
  • ora-29854 : keyword BITMAP may not be used in creating domain indexes
  • ora-06030 : NETDNT: connect failed, unrecognized node name
  • ora-01371 : Complete LogMiner dictionary not found
  • ora-32631 : illegal use of objects in MODEL
  • ora-28103 : adding a policy to an object owned by SYS is not allowed
  • ora-19575 : expected string blocks in file string, found string
  • ora-14188 : sub-partitioning columns must form a subset of key columns of a UNIQUE index
  • ora-12336 : cannot login to database (link name string)
  • ora-01258 : unable to delete temporary file string
  • ora-19500 : device block size string is invalid
  • ora-01561 : failed to remove all objects in the tablespace specified
  • ora-12602 : TNS: Connection Pooling limit reached
  • ora-19555 : invalid LOG_ARCHIVE_MIN_SUCCEED_DEST parameter value
  • ora-08233 : smsdes: cannot unmap SGA
  • ora-32126 : Cannot perform operations on a null REF
  • ora-06557 : null values are not allowed for any parameters to pipe icd's
  • ora-03132 : two-task default value overflow
  • ora-16232 : adding Logical Standby skip entry for table string.string
  • ora-29548 : Java system class reported: string
  • ora-12024 : materialized view log on "string"."string" does not have primary key columns
  • ora-31042 : Too many properties in type 'string'
  • ora-01986 : OPTIMIZER_GOAL is obsolete
  • 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.