Database DataWarehousing (MOSC)

MOSC Banner

Error SID numbers

edited Apr 13, 2012 2:52AM in Database DataWarehousing (MOSC) 1 comment
I was looking a specific error table (ps_e_s_payment_tbl and was wondering if one removes all rows from this table and the target table F_SF_PAYMENT, and when one runs this MDW job again, it pulls in the last error_sid for that table.    Here is my question, if say someone truncates these 2 tables, how could one go about resetting the error_sid for PS_E_PAYMENT_TBL, if this can be done?  Or can this not be done and one just has to continue with the next concurrent ERROR_SID number for the error table.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center