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).
