Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle dbf problem

Re: Oracle dbf problem

From: Anurag <>
Date: Mon, 22 Jul 2002 22:17:34 -0400
Message-ID: <>

Of course its possible. All it requires is wrong table creation (storage) settings.

Did you specify the Tables INITIAL, NEXT .... storage clauses when you created the tables?
Do you know what the default settings for the storage clause is. Maybe you did not specify a storage clause in your table creation and your default storage settings (tablespace settings) are huge.

Also, you have a PK on the table ... so yes you do have indexes on the table ...

I don't know where to start from, to help ...

Try this:
select table_name, pct_free, pct_used,

          initial_extent, next_extent, pct_increase from user_tables;

similar kind query with user_indexes

Then something like this (assuming your oracle version allows it): alter table mytable move tablespace mytablespace storage (INITIAL 32K NEXT 32K PCTINCREASE 0); ... choose your storage settings as seems proper ... do the same with indexes ......

....and please read the documentation first. Concepts ... SQL Reference ... ! Anurag

"Pauline Gu" <> wrote in message
> 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 - 21:17:34 CDT

Original text of this message