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;