Oracle dbf problem

From: Pauline Gu <peironggu_at_yahoo.com>
Date: 22 Jul 2002 18:11:26 -0700
Message-ID: <f40bbecb.0207221711.50cff407@posting.google.com>

hello,

Please help!!!!!!

I have a schema in which my total data size is about 7Mb. But when I looked at my tablespace, I saw that the used space is 4994.44Mb. How is that possible? How much space does a barebone table take? I have about 26 tables, with average of about 7 columns in each table, and all the columns are of the type of varchar2 (400) and number (32). I do not have blobs or clobs. I only have sequence and primary key, foreign key constraint on the tables, nothing else (not even index). Can anybody help me with this?

In this database, we have about 4 schemas. And we are running out of the space from a 16G hard drive. I could not insert any more data. Please help.

thanks.

Pauline Received on Mon Jul 22 2002 - 20:11:26 CDT