Change of nchar characterset

Mar 3, 2023 11:08PM

Hello

I would need to plug tablespace into DB with different nchar characterset. The source is UTF8 and I would need to use AL16UTF16.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Master table "SYS"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded

Source time zone is -04:00 and target time zone is +01:00.

import done in AL32UTF8 character set and AL16UTF16 NCHAR character set

export done in AL32UTF8 character set and UTF8 NCHAR character set

Warning: possible data loss in character set conversions

Starting "SYS"."SYS_IMPORT_TRANSPORTABLE_01": "sys/******** AS SYSDBA" transport_datafiles=/kisoft/dbdata/data/PRODCDB/F42E64BA571C021DE053A56217AC5002/datafile/o1_mf_af_data_bnp8nm8v_.dbf,/kisoft/dbdata/data/PRODCDB/F42E64BA571C021DE053A56217AC5002/datafile/o1_mf_af_index_bnp8nosd_.dbf,/kisoft/dbdata/data/PRODCDB/F42E64BA571C021DE053A56217AC5002/datafile/o1_mf_l_data_bnp8mymn_.dbf,/kisoft/dbdata/data/PRODCDB/F42E64BA571C021DE053A56217AC5002/datafile/o1_mf_l_indexe_bnp8n3o3_.dbf,/kisoft/dbdata/data/PRODCDB/F42E64BA571C021DE053A56217AC5002/datafile/o1_mf_s_data_bnp8n8vb_.dbf,/kisoft/dbdata/data/PRODCDB/F42E64BA571C021DE053A56217AC5002/datafile/o1_mf_s_indexe_bnp8ng2w_.dbf directory=BCK_DIR dumpfile=k1572dwh_space_std.dmp

Database Administration (MOSC)

Change of nchar characterset

Howdy, Stranger!

Category Leaderboard

Top contributors this month