Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle dbf problem
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" <peironggu_at_yahoo.com> wrote in message
news:f40bbecb.0207221711.50cff407_at_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 - 21:17:34 CDT