Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with table size (initial extent)

d_sengJul 15 2002
Hi,

I have imported a table from my client's database, which shows the following size parameters as displayed from the user_segments table :-

bytes : 33628160
blocks : 4105
extents : 1
initial_extent : 33611776
next_extent : 65536

The number of rows in the table is 0 (zero). I am wondering how the table size could become so large, while other tables in the schema in the same tablespace have normal initial extent size.
I then created a tablespace with an initial and next extent of 64k each, and imported the data into the tablespace, after which the table size and the initial extent for the table remained to be 33611776. This is the problem with 4-5 other tables out of a total of 500 tables.

Of course if i drop and recreate the table, there is no problem, and the initial extent size and the table size becomes 64k, same as per the tablespace.

Any suggestions? I do not want to drop the tables and recreate them.

Because of this problem, even an attempt to import a blank database is consuming 2 GB of hard disk space.

Thanks in advance
DSG
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 13 2002
Added on Jul 15 2002
5 comments
634 views