ORA-19736: can not plug a tablespace into a database using a different national character set

Cause : Oralce deos nto supportp lugigng atabelspaec inot a adtabsae uisng adifefren tnatoinalc harcaters et.

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

Usei mpotr/exoprt ro unolad/olad ot moev daat intsead.

update : 18-08-2017

ORA-19736 - can not plug a tablespace into a database using a different national character set
ORA-19736 - can not plug a tablespace into a database using a different national character set

  • ora-25007 : functions or methods not allowed in WHEN clause
  • ora-02034 : speed bind not permitted
  • ora-28534 : Heterogeneous Services preprocessing error
  • ora-00704 : bootstrap process failure
  • ora-29383 : all leaves of top-plan string must be consumer groups
  • ora-02251 : subquery not allowed here
  • ora-07757 : slemcc: invalid handle
  • ora-25504 : the system is already in quiesced state
  • ora-13295 : geometry objects are in different coordinate systems
  • ora-14190 : only one ENABLE/DISABLE ROW MOVEMENT clause can be specified
  • ora-02180 : invalid option for CREATE TABLESPACE
  • ora-32736 : Hang analysis aborted due to wrong message type
  • ora-22329 : cannot alter a non-object type
  • ora-39752 : redundant column in partitioning and join columns is not allowed
  • ora-12521 : TNS:listener does not currently know of instance requested in connect descriptor
  • ora-03293 : Cluster to be truncated is a HASH CLUSTER
  • ora-39751 : partitioned table on both sides of PARTITIONED OUTER JOIN is not supported
  • ora-07509 : scgfal: $deq parent lock unexpected return
  • ora-06254 : NETNTT: cannot share connection to cube
  • ora-19956 : database should have no offline immediate datafiles
  • ora-04075 : invalid trigger action
  • ora-09261 : spdcr: error creating detached (background) process
  • ora-16201 : Skip procedure requested to apply statement
  • ora-02468 : Constant or system variable wrongly specified in expression
  • ora-23538 : cannot explicitly refresh a NEVER REFRESH materialized view ("string")
  • ora-38445 : TOP clause not allowed with no statistics
  • ora-28156 : Proxy user 'string' not authorized to set role 'string' for client 'string'
  • ora-22900 : the SELECT list item of THE subquery is not a collection type
  • ora-19034 : Type not supported during schema generation
  • ora-09364 : Windows 3.1 Two-Task driver unable to create hidden window
  • 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.