DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: CREATE Database Command

Threaded View

  1. #1
    Join Date
    Nov 2000
    Posts
    175

    CREATE Database Command

    HI,

    Oracle 9.2.0.3
    UNIX AIX 5.2

    I am having trouble with the 9i create database command.

    I want to use the new locally managed tbsp for the system tablespace. I have tried several ways and still getting errors.

    I want:
    Local in all tbsp, no dictionary
    uniform sizing
    no auto extend

    See below.

    create database "$db"
    maxinstances 2
    maxlogfiles 32
    maxlogmembers 4
    maxloghistory 500
    maxdatafiles 32000
    datafile '/u09/oradata/ORACLE/prdgis02/system01.dbf' size 200M
    extent management LOCAL uniform size 128k
    character set UTF8
    national character set UTF8
    logfile group 1 ('/u10/oradata/ORACLE/prdgis02/redo01.log') size 250M,
    group 2 ('/u10/oradata/ORACLE/prdgis02/redo02.log') size 250M,
    group 3 ('/u10/oradata/ORACLE/prdgis02/redo03.log') size 250M
    default temporary tablespace TEMP
    tempfile '/u12/oradata/ORACLE/prdgis02/temp01.dbf' size 500M,
    '/u12/oradata/ORACLE/prdgis02/temp02.dbf' size 500M,
    '/u12/oradata/ORACLE/prdgis02/temp03.dbf' size 500M
    extent management LOCAL uniform size 1024k
    undo tablespace undotbs01
    datafile '/u13/oradata/ORACLE/prdgis02/undotbs01_1.dbf' size 500M extent amangement LOCAL uniform size 1024k;
    Last edited by kburrows; 12-19-2005 at 11:48 AM.

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