|
-
Your options are:
1) Export table, drop table, create table, import data.
2) ALTER TABLE ... MOVE
3) Truncate the table and repopulate:
CREATE temp_table AS select * from my_table;
TRUNCATE TABLE my_table;
INSERT INTO my_table SELECT * FROM temp_table;
COMMIT;
You can deallocate unused space above the high water mark using:
ALTER TABLE my_table DEALLOCATE UNUSED;
See:
http://otn.oracle.com/docs/products/...chema.htm#6870
Cheers
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|