Home » SQL & PL/SQL » SQL & PL/SQL » Tablespace Growth When Adding New Tables
Tablespace Growth When Adding New Tables [message #95] Sun, 13 January 2002 22:21 Go to next message
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 Go to previous message
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?
Previous Topic: oracle user_views.
Next Topic: How to specify IN and OUT in PL/SQL
Goto Forum:
  


Current Time: Wed Apr 01 07:24:52 CDT 2020