| creating one more database. [message #176768] |
Fri, 09 June 2006 08:54  |
shahnazurs
Messages: 240
Registered: June 2005
Location: India
|
Senior Member |
|
|
Hi Friends,
Oracle 9i release & Windows XP are the stuff is in my PC.I just wanted to create one more database,it is created successfully except running the following scripts
catalog.sql
catproc.sql
pupbld.sql
I have given the system datafile size as 100M, while running the above scripts i got the error saying
"unable to extent system tablespace...."
What i did is, i altered the datafile by adding 150M more i.e totally 250M and again i ran the above scripts!
Can anybody please suggest whether i am right? if not please let me know? as well as how much size we have to give for system tablespace minum?
|
|
|
|
| Re: creating one more database. [message #176874 is a reply to message #176768] |
Sun, 11 June 2006 01:16  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
I set mine to have a minumn of 1024 M for the system tablespace. You also need temp tablespace, controlfile, archivelog, and sysman tablespace. You should put your own tablespace for data and another for your indexes.
Don't mix data with indexes or system tablespaces.
Hope this helps.
Neil.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
