Try using PARALLEL and NOLOGGING clause while creating an index.
Thanks and regards,
Uday Chipkar| DBA - eCo BB & LLU | Tech Mahindra
Oberoi Garden Estate, Chandivali, Mumbai 400 072, INDIA
( Office: +91 22 6688 2539 | Cell: +91 9820006879
Email: [Email address protected]
www.techmahindra.com
-----Original Message-----
From: Shalini Gupta
[mailto:oracledba-ezmlmshield-x98729591.[Email address protected]
Sent: Friday, August 31, 2007 4:17 PM
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
============================================================================================================================
Disclaimer:
This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.
============================================================================================================================
Oracle LazyDBA home page