ORA-12716: Cannot ALTER DATABASE CHARACTER SET when CLOB
data exists



ORA-12716: Cannot ALTER DATABASE CHARACTER SET when CLOB data exists..

Answer / guest

Cause: CLOB data changes representation to Unicode when
converting to a multibyte character set and must be migrated

Action: Remove CLOB data as listed in the alert file. CLOB
data can be migrated by methods such as import/export

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02258: duplicate or conflicting NULL and/or NOT NULL specifications

1 Answers  


ORA-14024: number of partitions of LOCAL index must equal that of the underlying table

1 Answers  


ORA-01298: conflicting dictionary option

1 Answers  


KUP-04108: unable to reread file string

1 Answers  


ORA-15192: invalid ASM disk header [string] [string] [string] [string] [string]

1 Answers  






RMAN-08512: waiting for snapshot controlfile enqueue

1 Answers  


NNF-02005: NIS key string does not exist in map string

1 Answers  


ORA-07842: sllfcl: SYS$CLOSE failure

1 Answers  


ORA-16620: one or more databases could not be contacted for a delete operation

1 Answers  


ORA-06129: NETTCP: unable to transfer socket ownership to ORASRV

1 Answers  


ORA-27004: invalid blocksize specified

1 Answers  


ORA-31041: Property string: Memory type (string) not compatible with database type (string)

1 Answers  


Categories