-
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;
-
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?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|