Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> shrinking the table

shrinking the table

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Tue, 14 Nov 2006 08:54:23 -0500
Message-ID: <F4C27E77F7A33E4CA98C19A9DC6722A20167F693@EXCHANGE.corp.perceptron.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 14 2006 - 07:54:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US