Topic: Performance & Tuning >> reclaim unused disk space from table
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: reclaim unused disk space from table |
| satya |
Posted: Mar 29, 2008 03:13:30 AM |
Total Post: 1
Joined: Jun, 2007
|
Hi,
I am trying to shrink the space which has been allocated from the objects, using the following command:
ALTER TABLE DEPOSTS ENABLE ROW MOVEMENT
ORA-14066: illegal option for a non-partitioned table
Please help me in solving this problem.
thankyou
satyanag |
|
|
 Babu |
| Posted: Mar 29, 2008 08:17:41 AM |  |
|
Total Post: 77
Joined: Oct, 2007
|
ORA-14066: illegal option for a non-partitioned index-organized table
Cause: An attempt was made to issue a CREATE or ALTER TABLE command on a non-partitioned IOT, but the command contains an option that is legal only for partitioned index-organized tables. Such options are: ENABLE ROW MOVEMENT and DISABLE ROW MOVEMENT.
Action: Remove the illegal option(s) from the command.
|
|
|
|
|
| suraj_v |
| Posted: Mar 29, 2008 10:13:32 AM | |
|
Total Post: 7
Joined: Mar, 2008
|
Guys,
Change the compatiable parameter to 10.2.0
a. Enable row movement
SQL> ALTER TABLE scott.emp ENABLE ROW MOVEMENT;
b. Won't shrink High Water Mark).
SQL> ALTER TABLE scott.emp SHRINK SPACE COMPACT;
c. Shrink table and HWM .
SQL> ALTER TABLE scott.emp SHRINK SPACE;
d. Shrink table and all dependent index too.
SQL> ALTER TABLE scott.emp SHRINK SPACE CASCADE;
e. Shrink table under MView.
SQL> ALTER TABLE <table name> SHRINK SPACE;
Kind Regards,
Suraj
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Mohammed Taj | 634 |
| Murtuja Khokhar | 588 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 385 |
| Ramesh Jois | 226 |
| neeraj sharma | 189 |
| snehalatha p | 166 |
| Gitesh Trivedi | 157 |
| Gopu Gopi | 149 |
| Kushal ratnaker | 136 |
|
|
