Temp segment error in db creation(Urgent)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Temp segment error in db creation(Urgent)

  1. #1
    Join Date
    Dec 2002
    Location
    Chennai, India
    Posts
    104

    Temp segment error in db creation(Urgent)

    Hello Gurus,
    Iam trying to create a db on W2k,9i but my alter_log says the error(ORA-1652: unable to extend temp segment by 8 in tablespace).
    Could any one help me. My db creation script is provided here FYI.
    CREATE DATABASE acc
    MAXDATAFILES 256
    MAXINSTANCES 3
    MAXLOGFILES 62
    MAXLOGMEMBERS 5
    MAXLOGHISTORY 1600
    DATAFILE 'D:\db\acc\sysacc.dbf' size 5M reuse
    EXTENT MANAGEMENT LOCAL
    CHARACTER SET WE8ISO8859P1
    NATIONAL CHARACTER SET "AL16UTF16"
    DEFAULT TEMPORARY TABLESPACE TEMP
    TEMPFILE 'D:\db\acc\tmpacc.dbf'
    SIZE 5M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
    UNDO TABLESPACE "UNDOTBS1"
    DATAFILE 'D:\db\acc\rbsacc.dbf'
    SIZE 5M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
    LOGFILE 'D:\db\acc\log1acc.dbf' size 5M reuse,
    'D:\db\acc\log2acc.dbf' size 5M reuse,
    'D:\db\acc\log3acc.dbf' size 5M reuse,
    'D:\db\acc\log4acc.dbf' size 5M reuse,
    'D:\db\acc\log5acc.dbf' size 5M reuse;

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    You are trying to create a database with system tablespace consisting of one 5Mb datafile!!!! No wonder it can't create the database. Enlarge the size of the system datafile.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    In fact, if you are inquisitive enough, you can find information about minimum size of system tablespace. Using 5MB? This must be the first time you've tried this. And what is an alter_log? And what is so urgent about this problem?

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