Index creation a long time..Please help to tune the creation time.

Advertisement

Hi all,
I am creating a index after using impdp to put the data in that table.
Below is my index creation command.The index creation takes ~30 minutes .
Can the forum memebers suggest me how to put this index creation with parallel clause or otherwise to reduce the time it takes to create the index?
+++++++++++++++++++++++++++++++++++++++++++++++
spool incre_HUNTER_PK_1.log
set lines 200 pages 0 echo on feedback on timing on time on
alter session enable parallel dml;
alter session enable parallel ddl;
CREATE UNIQUE INDEX "HUNTER_PK" ON "HUNTER" ("HUNTER_NUM", "BILL_SEQ", "BILL_VERSION")
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING COMPUTE STATISTICS
STORAGE(INITIAL 4294967296 NEXT 16777216 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "HUNTER_LARGE_02";
ALTER TABLE HUNTER ADD PRIMARY KEY ("HUNTER_NUM", "BILL_SEQ", "BILL_VERSION") USING INDEX HUNTER_PK;
ALTER INDEX "HUNTER_PK" NOLOGGING NOPARALLEL;
spool off
+++++++++++++++++++++++++++++++++++++++++++++++
Some other details:
1. My imdp command import nearly the below details
. . imported "HUSTY"."HUNTER" 42.48 GB 218185783 rows
2. It is a non-partitioned table.
3. I cant drop the table at the target.
Regds,
Kunwar

Advertisement

Kunwar wrote:
Can the forum memebers suggest me how to put this index creation with parallel clause or otherwise to reduce the time it takes to create the index?
What version of the database?
Creating indexes in parallel is described in the documentation. Search the on-line documentation for the syntax for create index; if there aren't any specific examples of creating indexes in parallel do a Google search for "create index parallel"

November 30, -0001

Index creation a long time..Please help to tune the creation time.

Hi all, I am creating a index after using impdp to put the data in that table. Below is my index creation command.The index creation takes ~30 minutes . Can the forum memebers suggest me how to put this index creation with parallel clause or otherwis

I updated to Mountain Lion and now my Parallels application no longer works; please help! What to do???

I updated to Mountain Lion and now my Parallels application no longer works; please help! What to do???Make sure you have the latest version of parrallels. Think older versions are not compatible.Read other 2 answers

HT5624 My wife and I share the same apple id, we just updated our iphones. When we were asked if we wanted to share the same apple id for icloud we said yes, now our phones can't face time, please help?

My wife and I share the same apple id, we just updated our iphones. When we were asked if we wanted to share the same apple id for icloud we said yes, now our phones can't face time, please help?Read http://macmost.com/setting-up-multiple-ios-devices

Please help me find the error in the annex VI,access

Hello, everyone, this is a program about ACCESS, please help me find the error in the annex VI, why do I always run time error. Thank you very much. Attachments: write access test.vi ‏22 KBThank you for your reply, I have an attachment process map, c

[Urgent] Please help me verify the debug output on E&M interface.

Hello,     I've got a problem when trying to make a call from the E&M interface on the router to PABX(Panasonic). I've got any dail-tone back. Please help me verify the logging output. It seemed to already send the digits. ###########################

HT1338 Could you please help me with the problem. I have mac os 10.7.4 on my macbook pro retina and want to update it to 10.7.5. I had been waiting for 2 hours to do it, but then it appeared that it was impossible. What should I do?

Could you please help me with the problem. I have macbook with retina with mac os 10.7.4 ann want to update it to mac os 10.7.5. I had been waiting for 2 hours to do it and had tried 3 times but it appeared that it was impossible. What should I do?Yo

Please help me with the digital signature validation problem?

Please help me with the digital signature validation problem?Hi Execute the program in the Debuggin mode. In the Debugger Window Select Breakpoint -> Break point at -> Breakpoint at source code Menu Item and enter the details of the program/include/

Please help me with the accounting records of iTunes. At step in placing credit card details are asked to contact iTunes Support

Please help me with the accounting records of iTunes. At step in placing credit card details are asked to contact iTunes SupportBrenda, the easiest way to contact the support team is thru the iTunes Customer Service website: http://www.apple.com/supp

My iphone keeps freezing, then turning itself off. Please help me resolve the problem whatever it is

My iphone keeps freezing, then turning itself off. Please help me resolve the problem whatever it may be.You said that you restored it.  "forgot to mentioned that ive tried all of that" When you restore, you can restore from backup or as new. Di

Time Machine could not complete the backup "Time Capsule". Unable to access disk image backup "/ Volumes / Time Capsule / iMac.sparsebundle" (error 112). How can I repair it?

Time Machine could not complete the backup "Time Capsule". Unable to access disk image backup "/ Volumes / Time Capsule / iMac.sparsebundle" (error 112). How can I fix it?You might want to take a look at Pondini's excellent support doc

Remote Desktop Connection (RDC) No longer working - Please help!

Ok... here we go.  I cannot RDC to my network at work.  I originally was using a PC and was able to connect a few times using RDC before it stopped working.  It would not connect either wirelessly or connected via ethernet cable no matter what I trie

Apple application support Error 2 windows with lastest upgrade download is preventing me from opening itunes, unistalled, reinstalled 3 times, please help.

I recently downloaded the most current version of itunes automatically, got an error during the install process and was unable to open my existing itunes after that occurrance.  I unistalled and reinstalled 3 times. Says installed finished but when I

Fire fox starts by it self and goes to search site all the time please help or it is back to Internet explorer

fire fox starts by it self and goes to search site all the time please helpPossible malware infection Do a malware check with some malware scanning programs. You need to scan with all programs because each program detects different malware. Make sure

OS 10.6 - Please help - problem restoring system from time machine!

Hi there, Today I installed a little program to convert flac audio files to mp3. When I ran the program the computer froze, so I rebooted but then I could move the cursor but not click on any menus or icons on the desktop, they just wouldnt respond -

'find my ipad' enabled I cannot access the ipad as the use account originally set when new no longer exists, please help, now in DFU mode but still needs passcode!

I have deleted my Apple ID from the apple store but had it previously associated with my Ipad, that I set 'to find' my ipad. but since i've deleted the orginal account I cannot access my ipad! The ipad is currently in DFU mode but still asks for a pa

Please help - Victim of the disastrous Twist - Thinkpad s230u

I got fancied by a 2 minute preview of the Lenovo Twispad by a store associate and some online videos and decided to buy it. Now I am repenting my decision like a drug addict in rehab. I have multiple issues with this. I would've returned it, got it

My iphone wont turn on!! please help!! the apple logo turn on only.

okay so yesterday i went to apple store cos my iphone needed to be fix and today when i was about to put all my stuff in like from a back up i decided to erase all that was already on my iphone so it wont lake long, so i went into settings, rest, era

Sun Team: Please help me regarding the login action previously i posted

Hi sun team i have posted one thread recently. Please verify my code and guide me whether it is correct or not. And if any changes needed Please help me out regarding this. http://forum.java.sun.com/thread.jspa?threadID=5118906&tstart=0 Thank You in

Updated to the iOS 7 and now my iTunes Store keeps crashing and won't open please help, Updated to the iOS 7 and now my iTunes Store keeps crashing and won't open please help

I recently updated the software on my iPhone 5 and now I can't open my iTunes Store and e keypad seems really slow in responding. I have turn my phone in and off but it hasn't solved the issue. Can someone please help!It's not a bad install of Mounta

This my crash report please help to findout the problem

my firefox is crashing agian and again here is detail crash report .Add-ons: [email protected]:7.1.8,[email protected]:0.9.8.1,[email protected]:1.5.7,{3112ca9c-de6d-4884-a869-9855de68056c}:7.1.20110512W,{972ce4c6-7e08-4474-a285-3208198ce6fd}:3.6.18