Create index <The script> nologging parallel(4);
Nologging is important , avoid redo
Parallel will create in parallel

Thanks & Regards,
Himanshu Mahapatra
Corporate Oracle DBA
Warner Bros Entertainment UK Ltd
98 Theobald's Road
London
WC1X 8WB
Himanshu.[Email address protected]
* : +44 (0)207 984 5734
Mobile- 0044 -(0)7885990475

-----Original Message-----
From: Shalini Gupta
[mailto:oracledba-ezmlmshield-x98729591.[Email address protected]
Sent: 31 August 2007 11:47
To: LazyDBA Discussion
Subject: Fast index creation


Hi,

Any one can tell me how can i do fast index creation on big table. table

size is approx 10G.
Its very urgent.

Thanks & Best Regards,
Shalini Gupta
ITC Data Center, Bangalore



**********Please visit us at www.itcportal.com**********

************************************************************************
******
This Communication is for the exclusive use of the intended recipient
(s) and shall
not attach any liability on the originator or ITC Ltd./its
Subsidiaries/its Group
Companies. If you are the addressee, the contents of this email are
intended for your
use only and it shall not be forwarded to any third party, without first
obtaining
written authorisation from the originator or ITC Ltd./its
Subsidiaries/its Group
Companies. It may contain information which is confidential and legally
privileged
and the same shall not be used or dealt with by any third party in any
manner
whatsoever without the specific consent of ITC Ltd./its Subsidiaries/its
Group
Companies.
************************************************************************
********


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page