RE: local Bimap indexes -- thanks

2002-10-15 Thread sat0789
Thanks Kirti for the suggestion..it works now. Sathish. On Mon, 14 Oct 2002 19:53:23 -0800, Deshpande, Kirti [EMAIL PROTECTED] said: Create logon triggers for these Informatica user id to alter session set... - Kirti -Original Message- Sent: Monday, October 14, 2002 7:09

RE: local Bimap indexes

2002-10-14 Thread Khedr, Waleed
In Informatica there is a stored procedure transform (runs any Oracle SP) that you can make it pre source load. So the SP would be called before loading the table. Regards, Waleed -Original Message- Sent: Monday, October 14, 2002 7:04 PM To: Multiple recipients of list ORACLE-L Hello

RE: local Bimap indexes

2002-10-14 Thread sat0789
Thats what we exactly did except that iniformatica starts a separate session when it is loading the target which results in the error unusable state . sathish On Mon, 14 Oct 2002 15:44:02 -0800, Khedr, Waleed [EMAIL PROTECTED] said: In Informatica there is a stored procedure transform (runs

RE: local Bimap indexes

2002-10-14 Thread Deshpande, Kirti
Create logon triggers for these Informatica user id to alter session set... - Kirti -Original Message- Sent: Monday, October 14, 2002 7:09 PM To: Multiple recipients of list ORACLE-L Thats what we exactly did except that iniformatica starts a separate session when it is loading

RE: local Bimap indexes

2002-10-14 Thread Khedr, Waleed
Why do you have to make the indexes unusable? Can't you do a direct load into the table (nologging mode)? Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/14/02 7:08 PM Thats what we exactly did except that iniformatica starts a separate session when it