shrinking the table

  • From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 14 Nov 2006 08:54:23 -0500

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

Other related posts: