RE: local Bimap indexes -- thanks

Thanks Kirti for the suggestion..it works now.

Sathish.

On Mon, 14 Oct 2002 19:53:23 -0800, "Deshpande, Kirti" <kirti.deshpande_at_verizon.com> said:
> 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 the target
> which results in the error "unusable state" .
>
> sathish
>
> On Mon, 14 Oct 2002 15:44:02 -0800, "Khedr, Waleed"
> <Waleed.Khedr_at_FMR.COM> said:
> > 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 All,
> > This problem pertains to local bitmap index in dw env.
> >
> > We are using informatica to load our fact tables.
> >
> > i have a fact table partitioned on period key (range partition).
> > We have built local bitmap indexes on the foreign keys.
> > During the loading of the fact table for month 1, we are making the local
> > bitmap index partition pertaining to month 1
> > as UNUSABLE (through stored procedure being called at just before the
> > target is being loaded). In that same procedure
> > we also set ALTER SESSION SET SKIP_UNUSABLE_INDEXES = TRUE.
> > Once informatica starts to load the target, it opens up a new session
> > which in turn invalidates the alter session
> > and hence oracle terminates with an error saying "0ra-1052 index in
> > unusable state"
> > Please let me know if there is any workaround to this.
> > Is droping and recreating the bitmap index the ONLY option ???. this fact
> > table is going to grow to about 150 mill rows in
> > 12 month time frame , avg row length being 100 bytes)
> >
> >
> > oracle ver 9.2.,
> >
> >
> > TIA,
> >
> > sathish.
> >
> > --
> > http://fastmail.fm - The way an email service should be
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: sat0789_at_fastmail.fm
> >
> > 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.com
> > --
> > Author: Khedr, Waleed
> > INET: Waleed.Khedr_at_FMR.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).
> >
>
> --
> http://fastmail.fm - Access all of your messages and folders wherever you
> are
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: sat0789_at_fastmail.fm
>
> 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.com
> --
> Author: Deshpande, Kirti
> INET: kirti.deshpande_at_verizon.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).
>

-- 
http://fastmail.fm/ - A no graphics, no pop-ups email service
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: sat0789_at_fastmail.fm

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