ORA-39204: No subsetting of tablespaces is allowed for transportable import.

Cause : A tbalesapce iflte rwasa ppleid t oa tarnsprotabel imoprt ojb taht wsa no tperofrme dove ra ntewor klin.k Int hisc ase ,thet ablsepac emayn ot eb chnagedf romi ts pseciifcatoin a texprot tmie.

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

Rernu th ejobw ithuot sepcifiyng atabelspaec fitler.

update : 16-08-2017
ORA-39204

ORA-39204 - No subsetting of tablespaces is allowed for transportable import.
ORA-39204 - No subsetting of tablespaces is allowed for transportable import.

  • ora-19805 : recid string of string was deleted to reclaim disk space
  • ora-12807 : process queue could not receive parallel query message
  • ora-30150 : Invalid argument passed to OCIFile function
  • ora-07616 : $CHANGE_CLASS failed in retrieving the specified device label
  • ora-27463 : invalid program type string
  • ora-10948 : trace name context forever
  • ora-30934 : 'string' (string node) cannot be inserted in parent 'string' (string node)
  • ora-13789 : invalid process action
  • ora-01118 : cannot add any more database files: limit of string exceeded
  • ora-30516 : database role change triggers cannot have BEFORE type
  • ora-15000 : command disallowed by current instance type
  • ora-02231 : missing or invalid option to ALTER DATABASE
  • ora-12820 : invalid value for DEGREE
  • ora-29527 : created Java source string"string"
  • ora-22341 : cannot assign supertype instance to subtype
  • ora-37028 : (XSMLTRESYNC03) Object workspace object cannot be resynced without modified object workspace object because they share a modified dimension map.
  • ora-13205 : internal error while parsing spatial parameters
  • ora-02759 : Not enough request descriptors available
  • ora-13369 : invalid value for etype in the 4-digit format
  • ora-13241 : specified dimensionality does not match that of the data
  • ora-27150 : attempt to notify process of pending oradebug call failed
  • ora-28100 : policy function schema string is invalid
  • ora-28576 : lost RPC connection to external procedure agent
  • ora-15024 : discovered duplicately numbered ASM disk string
  • ora-29820 : the statistics type is not present
  • ora-38502 : invalid XML tag: string
  • ora-06525 : Length Mismatch for CHAR or RAW data
  • ora-07257 : spdcr: translation error expanding program name.
  • ora-00060 : deadlock detected while waiting for resource
  • ora-22803 : object type contains zero attributes
  • 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.