ORA-12701
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-12701

  1. #1
    Join Date
    Jul 2002
    Posts
    1
    Hi all,

    I changed My database NLS_CHARACTERSET wrongly.After shuting down and startup , it throws an error "ORA-12701 CREATE DATABASE character set is not known ".I am not able to do anything.Plz help me in this regard.
    Thanks in advance.
    Regards,
    jay.

  2. #2
    Join Date
    Sep 2001
    Posts
    62
    Hi,

    This error usually means that the charachter set you are refereing to does not exist on the system.

    what was the charachter set before you tried to change it ? and waht did you want to change it to ?

    I f you are using a charachter set other than the default US7ASCII, you have to set the following partamters depending on your operatins sytem and database version:

    RDBMS 7.2.x -> ORA_NLS
    RDBMS 7.3.x -> ORA_NLS32
    RDBMS 8.0.x -> ORA_NLS33
    RDBMS 8.1.x -> ORA_NLS33

    This parameter should
    point to your $ORACLE_HOME/ocommon/nls/admin/data directory.

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    What is the Oracle version? If < Oracle8i, then once the database is created, the character set cannot be easilly changed without recreating the database.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Mar 2002
    Posts
    301
    If u create the DB with scripts look at this scripts!
    usually this scripts are:Oracle_home\admin\sid\create\

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width