|
Re: Disable Oracle Index [message #61710 is a reply to message #61708] |
Wed, 19 May 2004 08:40 |
croca
Messages: 50 Registered: January 2004
|
Member |
|
|
If it is a primary key or unique constraint, you can
ALTER TABLE name DISABLE PRIMARY KEY
You can enable later, you can enable it NOVALIDATE so oracle will not validate data already inserted in the table, but will validate new inserted rows. This way you can save time thus oracle will 'recrete' the index transparently for those new records.
if it is a simple index you will have to drop it. You will loose the index and will have to recreate it if you need it.
Best luck.
Using RMAN backups?, try RMV from www.otools.com.ar
|
|
|
|
Re: Disable Oracle Index [message #61717 is a reply to message #61708] |
Wed, 19 May 2004 22:08 |
Daljit Singh
Messages: 290 Registered: October 2003 Location: Texas
|
Senior Member |
|
|
Hi,
Well according to me there is no need to drop the entire index, we can simply disable an index by issuing the following command :
ALTER INDEX IND_POL_ID UNUSABLE;
After that when we want to enable the index than we have to recreate the index that we can do using following command :
ALTER INDEX IND_POL_ID REBUILD;
Daljit Singh
|
|
|