Re: shrinking the table

From: Sunil Bhola <oraclebhola_at_yahoo.com>
Date: Fri, 1 Dec 2006 14:33:40 -0800 (PST)
Message-ID: <678297.17191.qm@web56207.mail.re3.yahoo.com>

Hi Igor,  

Alter table <table name> deallocate unused.  

Are you looking for this?  

Regards,
Sunil Bhola

• Original Message ----- From: Igor Neyman To: oracle-l_at_freelists.org Sent: Tuesday, November 14, 2006 7:24 PM Subject: shrinking the table

  Is there any trick, which allows to shrink the table:    

  ALTER TABLE <table_name> SHRINK SPACE CASCADE;    

  without invalidating the package, which depends on (references) this table?    

  Oracle version 10.1.0.2.    

  Igor  

---

Everyone is raving about the all-new Yahoo! Mail beta.
--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 01 2006 - 16:33:40 CST