Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: After Logon Trigger and Import
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" <orarup_at_hotmail.c To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> om> cc: Sent by: Subject: Re: After Logon Trigger and Import ml-errors_at_fatcity .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" <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). -- 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).Received on Tue Aug 05 2003 - 23:34:23 CDT
![]() |
![]() |