Changing table size

[Marios Varnava]

Hello people,
I have some tables in my database that are taking much space with
little data in them, so i need to change their size.
ex.
TableA -Size 5MB, Data Size 100KB
TableB -Size 5MB, Data Size 100KB

Database: Oracle 7.3.4.0.0

Is there a way to make table size 1MB?
Can i do this without making temp tables, copying the data from
current table to temp table .........?????

Any ideas are welcome.
Thanks.

[Daniel Roy]

Re: Changing table size

I'm not too sure if it existed in your version, but at least in 8i you
can try: "alter table ... deallocate unused keep ...K". This will
release the unused extents (if there are any), and keep ...K unused.
If that doesn't reduce enough the size of the table to your taste, you
might need to resort to the creation of a table ("create table ...
storage(...) nologging as select * from ...).

Daniel