Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2012
    Posts
    13

    Unanswered: Can we give Character set and National character set together

    Hi Experts,

    I had a problem with the controlfile while creating the database. My doubt is, Can we give both character set and National character set together in a controlfile. Following is the script for controlfile please check it and let me know if it was anything wrong.

    CREATE DATABASE GOLDDBB
    USER SYS IDENTIFIED BY gold21!
    USER SYSTEM IDENTIFIED BY gold221!
    LOGFILE
    GROUP 1 (
    '/redo/oracle/oradata/golddbb/redo11.log',
    '/redo/oracle/oradata/golddbb/redo12.log'
    ) SIZE 1535M BLOCKSIZE 512,
    GROUP 2 (
    '/redo/oracle/oradata/golddbb/redo21.log',
    '/redo/oracle/oradata/golddbb/redo22.log'
    ) SIZE 1535M BLOCKSIZE 512,
    GROUP 3 (
    '/redo/oracle/oradata/golddbb/redo31.log',
    '/redo/oracle/oradata/golddbb/redo32.log'
    ) SIZE 1535M BLOCKSIZE 512,
    GROUP 4 (
    '/redo/oracle/oradata/golddbb/redo41.log',
    '/redo/oracle/oradata/golddbb/redo42.log'
    ) SIZE 1535M BLOCKSIZE 512,
    GROUP 5 (
    '/redo/oracle/oradata/golddbb/redo51.log',
    '/redo/oracle/oradata/golddbb/redo52.log'
    ) SIZE 1535M BLOCKSIZE 512,
    GROUP 6 (
    '/redo/oracle/oradata/golddbb/redo61.log',
    '/redo/oracle/oradata/golddbb/redo62.log'
    ) SIZE 1535M BLOCKSIZE 512
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 2336
    CHARACTER SET WE8MSWIN1252
    NATIONAL CHARACTER SET AL32UTF8
    DATAFILE '/data1/oracle/oradata/golddbb/data/system01.dbf' SIZE 2048M
    AUTOEXTEND OFF NEXT 10M MAXSIZE 10G
    LOGGING
    ONLINE
    PERMANENT
    EXTENT MANAGEMENT LOCAL AUTOALLOCATE
    BLOCKSIZE 8K
    FLASHBACK ON
    SYSAUX DATAFILE '/data1/oracle/oradata/golddbb/data/sysaux01.dbf' SIZE 2048M
    AUTOEXTEND OFF NEXT 10M MAXSIZE 10G
    LOGGING
    ONLINE
    PERMANENT
    EXTENT MANAGEMENT LOCAL AUTOALLOCATE
    BLOCKSIZE 8K
    SEGMENT SPACE MANAGEMENT AUTO
    FLASHBACK ON
    DEFAULT TEMPORARY TABLESPACE TEMP1 TEMPFILE
    '/undotmp/oracle/oradata/golddbb/temp/TEMP01.dbf ' SIZE 30720M
    AUTOEXTEND ON NEXT 10M MAXSIZE 40G TABLESPACE GROUP
    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 16M
    UNDO TABLESPACE UNDOTBS1 DATAFILE /undotmp/oracle/oradata/golddbb/undo/UNDOTBS01.dbf SIZE 30720M AUTOEXTEND ON NEXT 5M MAXSIZE 40G
    ONLINE
    RETENTION NOGUARANTEE
    BLOCKSIZE 8K
    FLASHBACK ON
    ;


    Whenever i run the controlfile, it giving error message like Character set is invalid. Any one please let me get out of this problem


    Thanks in advance
    Dileep Kumar N

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    CREATE DATABASE

    "CHARACTER SET Clause

    Specify the character set the database uses to store data. The supported character sets and default value of this parameter depend on your operating system."
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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