Kodowanie znaków Oracle XE

Jeśli mamy problemy z importem danych, schematu w Oracle XE to można się spodziewać że problem jest po stronie kodowania znaków.

Aby rozwiązać problem

Uruchamiamy SQLPlus wpisujemy

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE EE8MSWIN1250;
SHUTDOWN IMMEDIATE;
STARTUP OPEN;

EXIT

Cały przebieg operacji powinien tak wyglądać

SQL*Plus: Release 11.2.0.2.0 Production on So Mar 21 23:49:02 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.



Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

SQL> SET SERVEROUTPUT ON

SQL> 
SQL> SHUTDOWN IMMEDIATE;

Database closed.

Database dismounted.

ORACLE instance shut down.
SQL> STARTUP MOUNT;

ORACLE instance started.

Total System Global Area  552402944 bytes
Fixed Size    1384872 bytes
Variable Size  167775832 bytes
Database Buffers  377487360 bytes
Redo Buffers    5754880 bytes

Database mounted.

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;


System altered.

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;


System altered.

SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;

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 OPEN;

ORACLE instance started.

Total System Global Area  552402944 bytes
Fixed Size    1384872 bytes
Variable Size  167775832 bytes
Database Buffers  377487360 bytes
Redo Buffers    5754880 bytes

Database mounted.

Database opened.
SQL> 
SQL> EXIT
Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production