Home » RDBMS Server » Performance Tuning » Queries in oracle indexing (oracle, 10.1.0.5.0, sun solaris)
Queries in oracle indexing [message #435717] Thu, 17 December 2009 10:19 Go to next message
sathik
Messages: 196
Registered: August 2009
Location: INDIA
Senior Member
I have a range partitioned table contains 4 partitions and the table has 2 normal indexes.

When I was dropping an one partition from the table through the following way,

alter table <table_name> drop partition <partition_name>;

the indexes are present in the table become UNUSABLE.

So to avoid this, Shall I use the below query to drop a partition?

alter table <table_name> drop partition <partition_name> update global indexes;

Note: there are 2 CLOB columns in that table.

[Updated on: Thu, 17 December 2009 10:39]

Report message to a moderator

Re: Queries in oracle indexing [message #435721 is a reply to message #435717] Thu, 17 December 2009 10:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes, you can.
Why don't you just try it instead of posting the question?

Regards
Michel

Report message to a moderator

Re: Queries in oracle indexing [message #435725 is a reply to message #435721] Thu, 17 December 2009 10:42 Go to previous messageGo to next message
sathik
Messages: 196
Registered: August 2009
Location: INDIA
Senior Member

Thanks for your immediate response.
It is a production db. So just like that I cannot try. Thatsy..

for any type of indexes, can I use this format?

Report message to a moderator

Re: Queries in oracle indexing [message #435727 is a reply to message #435725] Thu, 17 December 2009 10:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
It is a production db. So just like that I cannot try. Thatsy..

So you will trust and execute in production a statement you will get from a forum.
Gee! Good luck for the future.

You can do it for all global indexes but you should read the documentation about the consequences and restrictions of this statement.
When you rebuild online all statements that the index and is running may fail with an ORA-01555 or ORA-01410 error.

Regards
Michel

Report message to a moderator

Re: Queries in oracle indexing [message #435728 is a reply to message #435725] Thu, 17 December 2009 10:53 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>It is a production db. So just like that I cannot try. Thatsy..
You should have a working copy of Oracle RDBMS on your workstation!

Report message to a moderator

Previous Topic: select clause
Next Topic: Why Oracle 10g slows down Copmuter after few days
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 13:04:56 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.