Thanks very much Arup for your suggestion. Actually, Tables and indexes are already exist in the schema. I just have to copy the data from one environment to other environment. So I thought I will make the indexes unusable, load the data and rebuild the indexes with nologging, parallel and compute statistics.
Best Regards, Prasad 860 843 8377 "Arup Nanda" <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> om> cc: Sent by: Subject: Re: After Logon Trigger and Import [EMAIL PROTECTED] .com 08/05/2003 08:29 PM Please respond to ORACLE-L Prasad, You can use SKIP_UNUSABLE_INDEXES=Y as an import parameter. But then again, why do that? Why not just impirt with INDEXES=N and then rebuild the indexes in parallel and with NOLOGGING? HTH. Arup Nanda ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, August 05, 2003 1:19 PM > > Sorry, I forgot to mention the OS and Oracle Version. It is Hp-UX v11 and > Oracle 8.1.7.4 > > Thanks. > > Best Regards, > Prasad > 860 843 8377 > > > > Prasada R Gunda > To: [EMAIL PROTECTED] > 08/05/2003 12:21 cc: > PM Subject: After Logon Trigger and Import(Document link: Prasada R Gunda) > > > > > > Hi, > > I put the 'alter session set skip_unusable_indexes=true' in the logon > trigger of a particular user and tested it in the sql*plus session. It is > working fine there. I tested it by making an index unusable and inserting > the data into the table. > > But, when I tried to import (using the same user) the data into that table, > It gives an error saying that 'Index is in unusable state'. > > Does logon trigger fire for the Import? Is there any way to verify that > the skip_unusable_indexes is set to 'true' for a particular session. > > Thanks in advance for your help. > > Best Regards, > Prasad > 860 843 8377 > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).