RE: local Bimap indexes

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