Home » RDBMS Server » Server Administration » table partition drop with update global index class`
table partition drop with update global index class` [message #350943] Sun, 28 September 2008 00:34 Go to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
Experts,

i need to drop old partitions drop in a huge table. i am using
alter table <table name> drop partitions <partition name>
update global index parallel 5;

i have some questions.

what are the considerations i need to take care while dropping the partitions.

does it affects the performance of other queries?
what about local index defined on the partition, above statement will drop local indexes?

what are the pros and corns while dropping the partitions.

can any one guide me
table partition drop with update global index class` [message #350944 is a reply to message #350943] Sun, 28 September 2008 00:37 Go to previous messageGo to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
Experts,

i need to drop old partitions drop in a huge table. i am using
alter table <table name> drop partitions <partition name>
update global index parallel 5;

i have some questions.

what are the considerations i need to take care while dropping the partitions.

does it affects the performance of other queries?
what about local index defined on the partition, above statement will drop local indexes?

what are the pros and corns while dropping the partitions.

can any one guide me
Re: table partition drop with update global index class` [message #350950 is a reply to message #350943] Sun, 28 September 2008 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
what about local index defined on the partition, above statement will drop local indexes?

It will drop the index partition that is associated to the table one.

Quote:
what are the pros and corns while dropping the partitions

Comparing to what?

Regards
Michel
Re: table partition drop with update global index class` [message #351197 is a reply to message #350943] Mon, 29 September 2008 16:56 Go to previous messageGo to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
while dropping partitions,
what are the other facts does affect the performance of the db.

is there any other things i need to focus on while doping the partitions?


This kind of work i haven't done in the past. so i am asking help from experts.

Re: table partition drop with update global index class` [message #351231 is a reply to message #351197] Tue, 30 September 2008 01:00 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
what are the other facts does affect the performance of the db.

Anything that involves the table or partition.
Anything that involves the database
Anything that involves the disk
Anything that involves the server
...

Quote:
is there any other things i need to focus on while doping the partitions?

Do it when nobody try to access to it.

Regards
Michel
Previous Topic: Copy ASM Files
Next Topic: What is the Default password for the SYS user in oracle 10g
Goto Forum:
  


Current Time: Sat Dec 03 20:13:01 CST 2016

Total time taken to generate the page: 0.11440 seconds