Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Usenet ->
c.d.o.server ->
Migrating NLS_LENGTH_SEMANTICS from BYTE to CHAR
Migrating NLS_LENGTH_SEMANTICS from BYTE to CHAR
ORACLE RDBMS Version: 10.2.0.2.0
- My dumps are in BYTE length semantics.
- Altering system NLS_LENGTH_SEMANTICS=CHAR has a limited effect (only
new objects are created with new semantics).
- Trying to alter existing schema objects to CHAR semantics
efficiently render schema unusable - from my experience.
- Any export/import operation retains length semantics of the source
without options to alter.
- One of the possibilities of altering data successfully is to create
a new schema with definitions altered to CHAR semantics, e.g. by
extracting and changing DDL from dump file, and then importing data
onto newly created schema skeleton.
- Other methods are data pump, and dblink, with the former failing to
import all of the SQL data, and latter... I didn't try.
Received on Fri May 19 2006 - 03:49:50 CDT
Original text of this message