| Tablespace Growth When Adding New Tables [message #95] |
Sun, 13 January 2002 22:21  |
David Griffiths
Messages: 2
Registered: January 2002
|
Junior Member |
|
|
I'm adding some new tables to our database, and adding them to the tablespace that I created for larger tables.
Each data file has an initial size of about 1 gig, and the max extent is 2 gig. The next extent is 64k.
After adding a single table, the database grabs about one hundred meg of space.
This is our quality assurance database - I don't want this happening on our production machines.
What am I doing wrong.
BTW, the database is 8i, version 8.1.6.3.3.
Thanks,
David
|
|
|
|
| Re: Tablespace Growth When Adding New Tables [message #99 is a reply to message #95] |
Mon, 14 January 2002 02:47  |
Mike
Messages: 417
Registered: September 1998
|
Senior Member |
|
|
Which is the inital extent of the table you are creating?
Are you creating any primary key or unique key? If yes on which tablespace are they stored and which is their initial extent?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
