Changing Character Set Problems [message #2630] |
Thu, 01 August 2002 06:55 |
Hugh
Messages: 7 Registered: April 2002
|
Junior Member |
|
|
Hi I am trying to change the character set on my Oracle 9i server to zht16hkscs.
Below is a dump of the sql+ that I have tried.
Initial problems are with SYSTEM not having correct pivileges - should I be using system?
Then there is the problem with the character set not being a superset of the old character set.
-any ideas of how I can overcome these problems?
Cheers
Hugh
SQL*Plus: Release 9.0.1.0.1 - Production on Thu Aug 1 15:04:19 2002
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
SQL> connect
Enter user-name: system
Enter password: *******
Connected.
SQL> shutdown immediate;
ORA-01031: insufficient privileges
SQL> shutdown normal;
ORA-01031: insufficient privileges
SQL> startup mount;
ORA-01031: insufficient privileges
SQL> alter system enable restricted session;
System altered.
SQL> alter system set job_queue_processes=0;
System altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01531: a database already open by the instance
SQL> alter database character set zht16hkscs;
alter database character set zht16hkscs
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set
SQL> shutdown immediate;
ORA-01031: insufficient privileges
SQL>
|
|
|
|