Home » SQL & PL/SQL » SQL & PL/SQL » Parallelize alter table statement (Oralce 10g)
Parallelize alter table statement [message #399282] Tue, 21 April 2009 07:21 Go to next message
bholeuday
Messages: 28
Registered: April 2009
Location: Talavali
Junior Member

Hi,

Is there any way by which i can parallelize below query

ALTER TABLE documents_ud RENAME COLUMN custodian TO capture_business_unit_code;

ALTER TABLE documents_ud MODIFY (capture_business_unit_code VARCHAR2(3));

Thanx in advance Smile

Uday
Re: Parallelize alter table statement [message #399287 is a reply to message #399282] Tue, 21 April 2009 07:36 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no need to parallelize these statements that wil update only one line in a couple of dictionary tables.

Regards
Michel
Previous Topic: Error when stored proc called from vb.net
Next Topic: Parse SQL: Extract column expression and labels from SQL query
Goto Forum:
  


Current Time: Sat Dec 03 13:48:24 CST 2016

Total time taken to generate the page: 0.07084 seconds