Home » SQL & PL/SQL » SQL & PL/SQL » How to shrink the size of a table its indexes after a delete command?
How to shrink the size of a table its indexes after a delete command? [message #240919] Sun, 27 May 2007 14:17 Go to next message
Ivancleber da Silva Neves
Messages: 74
Registered: July 2002
Member
How to shrink the size of a table its indexes after a delete command? How to move the high watermark after a delete ?

Thanks

Re: How to shrink the size of a table its indexes after a delete command? [message #240921 is a reply to message #240919] Sun, 27 May 2007 15:14 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
In oracle 10g

alter table my_table enable row movement;

alter table my_table shrikn space;>>>>>>>>>>>only for table

alter table my_table shrink space cascade;>>>>table and indexes;

http://sysdba.wordpress.com/2006/04/28/how-to-adjust-the-high-watermark-in-oracle-10g-alter-table-shrink/
Previous Topic: Database Design
Next Topic: send mail through oracle
Goto Forum:
  


Current Time: Sun Dec 04 00:43:14 CST 2016

Total time taken to generate the page: 0.08125 seconds