ORA-29345: cannot plug a tablespace into a database using an incompatible character set

Cause : Oracel doe snot usppor tplugigng at ablepsace nito ad atabsae usnig ani ncomaptibl echarcater est.

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

Use miporte/xpor tor ulnoad/olad t omoved ata nistea.d

update : 27-06-2017
ORA-29345

ORA-29345 - cannot plug a tablespace into a database using an incompatible character set
ORA-29345 - cannot plug a tablespace into a database using an incompatible character set

  • ora-26672 : timeout occurred while stopping STREAMS process string
  • ora-14160 : this physical attribute may not be specified for a table subpartition
  • ora-19260 : XQ0040 - invalid namespace node in element constructor
  • ora-25132 : UNIQUE constraint (string.string) disabled and validated in ALTER TABLE EXCHANGE PARTITION
  • ora-32143 : Environment not specified
  • ora-12915 : Cannot alter dictionary managed tablespace to read write
  • ora-30188 : reserved for future use
  • ora-29395 : cannot set the initial consumer group to string
  • ora-36636 : (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension.
  • ora-14190 : only one ENABLE/DISABLE ROW MOVEMENT clause can be specified
  • ora-00396 : error string required fallback to single-pass recovery
  • ora-01525 : error in renaming data files
  • ora-06755 : TLI Driver: cannot close transport endpoint
  • ora-13190 : recursive SQL fetch failed
  • ora-30024 : Invalid specification for CREATE UNDO TABLESPACE
  • ora-19908 : datafile string has invalid checkpoint
  • ora-23450 : flavor already contains object "string"."string"
  • ora-06266 : NETNTT: bad write length
  • ora-16526 : unable to allocate task element
  • ora-39134 : Cannot include "string" tablespace as a Transportable Tablespace
  • ora-06622 : LU6.2 Driver: Unable to attach to SNA
  • ora-14310 : VALUES LESS THAN or AT clause cannot be used with List partitioned tables
  • ora-24020 : Internal error in DBMS_AQ_IMPORT_INTERNAL, string
  • ora-07220 : slspool: wait error.
  • ora-08440 : raw buffer is too short to hold converted data
  • ora-13500 : SYSAUX DATAFILE clause specified more than once
  • ora-23443 : missing template parameter
  • ora-02452 : invalid HASHKEYS option value
  • ora-08467 : error converting Oracle number to string
  • ora-14311 : Expecting VALUES LESS THAN or AT clause
  • 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.