Změna znakové sady na Oracle XE

IMP-00019: row rejected due to ORACLE error 12899
 IMP-00003: ORACLE error 12899 encountered
 ORA-12899: value too large for column "ORACLE_DBA"."BASE01"."MIS_NAROZ" (actual: 26, maximum: 25)

Oracle XE edition

SQL> SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;

VALUE$
 --------------------------------------------------------------------------------

AL32UTF8

SQL> shutdown immediate
 Database closed.
 Database dismounted.
 ORACLE instance shut down.
 SQL> startup mount
 ORACLE instance started.

Total System Global Area 1068937216 bytes
 Fixed Size 2260048 bytes
 Variable Size 671089584 bytes
 Database Buffers 390070272 bytes
 Redo Buffers 5517312 bytes
 Database mounted.
 SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

System altered.

SQL> ALTER DATABASE OPEN;

Database altered.

SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE EE8MSWIN1250;

Database altered.

SQL> shutdown immediate
 Database closed.
 Database dismounted.
 ORACLE instance shut down.
 SQL> startup
 ORACLE instance started.

Total System Global Area 1068937216 bytes
 Fixed Size 2260048 bytes
 Variable Size 671089584 bytes
 Database Buffers 390070272 bytes
 Redo Buffers 5517312 bytes
 Database mounted.
 Database opened.
 SQL> SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;

VALUE$
 --------------------------------------------------------------------------------
 EE8MSWIN1250

Komentáře