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
Messages: 28
Registered: April 2009
Location: Talavali
Junior Member


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

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: 65090
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.

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: Thu Jul 27 11:47:43 CDT 2017

Total time taken to generate the page: 0.08948 seconds