Try setting more SORT_AREA_SIZE for your session and then initiate the
index creation

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-x12298688.[Email address protected]
Sent: Friday, August 31, 2007 4:41 PM
To: LazyDBA Discussion
Subject: Fw: Fast index creation


Both the things are here, but still it is taking to much time.

Thanks & Best Regards,
Shalini Gupta






"Mahapatra Himanshu \(*IC\) " <Himanshu.[Email address protected]
08/31/2007 04:29 PM

To
SHALINI.[Email address protected]
cc

Subject
RE: Fast index creation






**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


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
[Email address protected]
* : +44 (0)207 984 5734
Mobile- 0044 -(0)7885990475

-----Original Message-----
From: Shalini Gupta
[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







**********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