FreeLists / oracle-l / Re: shrinking the table

[oracle-l] || [Date Prev] [12-2006 Date Index] [Date Next] || [Thread Prev] [12-2006 Thread Index] [Thread Next]

Re: shrinking the table

From: Sunil Bhola <oraclebhola@xxxxxxxxx>
To: ineyman@xxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
Date: Fri, 1 Dec 2006 14:33:40 -0800 (PST)

Hi Igor,
 
Alter table <table name> deallocate unused.
 
Are you looking for this?
 
Regards,
Sunil Bhola
  ----- Original Message ----- 
  From:   Igor   Neyman 
  To: oracle-l@xxxxxxxxxxxxx 
  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.