URGENT! Cannot create my database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: URGENT! Cannot create my database

Hybrid View

  1. #1
    Join Date
    Dec 2000
    Posts
    16
    When I execute the CREATE DATABASE statement, I'm getting the following error:
    "SQL Statement not properly ended"

    Here's my CREATE DATABASE STATEMENT:
    CREATE DATABASE CIT
    CONTROLFILE REUSE
    DATAFILE '/u03/oradata/CIT/CIT_sys1.dbf' SIZE 20M AUTOEXTEND ON NEXT 10M MAXSIZE 150M
    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
    LOGFILE
    GROUP 1 ('/u04/oradata/CIT/CIT_rdo1.rdo',
    '/u04/oradata/CIT/CIT_rdo2.rdo') SIZE 2M REUSE,
    GROUP 2 ('/u06/oradata/CIT/CIT_rdo3.rdo',
    '/u06/oradata/CIT/CIT_rdo4.rdo') SIZE 2M REUSE
    MAXLOGFILES 16
    MAXDATAFILES 16
    MAXLOGMEMBERS 4
    CHARACTER SET "WE8DEC"
    MAXINSTANCES 1
    NOARCHIVELOG

    Thanks

  2. #2
    Join Date
    Dec 2000
    Posts
    43
    You have to specify the filesize (2M e.g.) for each file and not for the group.

  3. #3
    Join Date
    Dec 2000
    Posts
    16
    no arshiah.
    My problem has to do with the fact that I'm trying to create the SYSTEM tablespace with "EXTENT MANAGEMENT LOCAL SIZE 1M".
    I get rid of this line and it work. But I still want to know how to specified this during the database creation.
    Thanks.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Tablespace SYSTEM is not supported to use local managed tablespaces. It still has to be dictionary managed

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    to pando,

    Generally also we don't have much control on SYSTEM tablespace other than resize/increase the tablespace. It creates its own extents by default and what are the issues in modfying system tablespaces extents ? Any Idea ?

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Hi

    you can modify sql.bsq before create the database, in sql.bsq default extent initial, next sizes are defined. Although rumour says that if we modified sql.bsq we have to face the consequences without Oracle support however I have read in metalink suggesting experienced DBAs change sql.bsq... so I dunno what´s true :P

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