Home » Server Options » Text & interMedia » oracle (10.1.0.3)
oracle [message #352780] |
Thu, 09 October 2008 09:31  |
ankush_chawla
Messages: 136 Registered: November 2006
|
Senior Member |
|
|
The DR$ index size is growing at a very rapid rate.
we are using the command
ctx_ddl.optimize_index() on daily basis. However it takes a long time and size is too large . While the operation on the system are normal.
We searched for it and find the solution to use below command for the table
alter table <tablename> shrink space cascade.
But the metalink note says that its tested on 10gR2
Is there any alternative available for 10gR1.
Regards
Ankush Chawla
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Wed Feb 19 13:43:24 CST 2025
|