CREATE DATABASE character set is not allowed

From: Jaroslav Mechacek <jara_at_ics.muni.cz>
Date: Thu, 11 Jun 1998 12:25:06 GMT
Message-ID: <357FCCA1.FD77F18E@ics.muni.cz>

Hi,

I am unable to create the the database with CHARACTER SET specified ( Oracle 8.0.4, Solaris 2.6 (sparc) )

example:

CREATE DATABASE dev
NOARCHIVELOG CHARACTER SET EE8ISO8859P2 LOGFILE GROUP 1 ('/oracle/oradata/v1/dev/log1.dbf' ,
'/oracle/oradata/v2/dev/log1.dbf') SIZE 5M,

GROUP 2 ('/oracle/oradata/v1/dev/log2.dbf' ,
'/oracle/oradata/v2/dev/log2.dbf') SIZE 5M
DATAFILE '/oracle/oradata/v1/dev/system.dbf' SIZE 30M AUTOEXTEND ON NEXT 20M MAXSIZE 130M;
;

says:

ORA-12706: this CREATE DATABASE character set is not allowed

It is possible to create the database using UTF8 or when not specifying the charset.

oerr ora 12706 says

12706, 00000, "this CREATE DATABASE character set is not allowed" // *Cause: It is not allowed to create a database on a native ASCII-based
// machine using an EBCDIC-based character set, and vice versa. // *Action:

Oracle 7.3 works fine on this machine.

Jaroslav Mechacek Received on Thu Jun 11 1998 - 07:25:06 CDT