Re: After Logon Trigger and Import

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" <ORACLE-L_at_fatcity.com> 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:
ORACLE-L_at_fatcity.com
> 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: Prasada.Gunda_at_hartfordlife.com
>
> 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: ListGuru_at_fatcity.com (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: orarup_at_hotmail.com

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: ListGuru_at_fatcity.com (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).