create a new Oracle 10g database instance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: create a new Oracle 10g database instance

  1. #1
    Join Date
    Dec 2001
    Location
    Duluth, Georgia, USA
    Posts
    99

    Question create a new Oracle 10g database instance

    Hi,

    I am trying to create a new Oracle 10g database instance. It failed with "ERROR at line 1: ORA-25146: EXTENT MANAGEMENT option already specified". Below is part of the script. I don't know what could be wrong. Thanks alot.

    create database
    datafile
    '/u01/oradata/def10g/system01.dbf'
    size 100M
    reuse
    autoextend on
    extent management local
    sysaux
    datafile '/u01/oradata/def10g/sysaux01.dbf'
    size 100M
    reuse
    autoextend on
    extent management local
    segment space management auto
    undo tablespace undo_ts
    datafile '/space/oracle/admin/def10g/data/undo.dbf'
    size 100M
    reuse
    autoextend on
    extent management local
    default temporary tablespace temp_df tempfile '/space/oracle/admin/def10g/data/tempdf.dbf'
    size 100M
    reuse
    autoextend on
    extent management local uniform size 20M;

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,470

    Cool


    You could try using dbca to create the database (and/or scripts).
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Apr 2006
    Posts
    23
    Kindly comment any one statement in your script
    extent management local
    extent management local uniform size 20M;

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