471,108 Members | 1,334 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

Changing table size

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.
TableA -> Size 5MB, Data Size 100KB
TableB -> Size 5MB, Data Size 100KB

Database: Oracle

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.
Jul 19 '05 #1
1 5280
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 ...).

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Joe Smith | last post: by
1 post views Thread by Marios Varnava | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.