Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 14 2006 - 07:54:23 CST
![]() |
![]() |