Re: Not able to insert to an imported table
From: rjamya <rjamya_at_gmail.com>
Date: Tue, 27 Aug 2013 12:18:27 -0400
Message-ID: <CAGurbTO3oe8Yoebi=LtniOWBbNo5A_5pxggEhtfshcTeM1hUfQ_at_mail.gmail.com>
Was there a remap_schema while doing a impdp? if so, that could be one of your problem. We really need to see the trigger text to identify the issue. Since it mentions dbms_session, it could be that you are missing privileges related to contexts? there are multiple possibilties. Please compare privileges from dba_sys_privs for the user in source and target and see what is missing. Also compare tab_privs, it could be that one of the table privs from another schema is missing? Check impdp log for reported issues as well.
I wouldnt try inserting until that trigger compiles correctly.
Date: Tue, 27 Aug 2013 12:18:27 -0400
Message-ID: <CAGurbTO3oe8Yoebi=LtniOWBbNo5A_5pxggEhtfshcTeM1hUfQ_at_mail.gmail.com>
Was there a remap_schema while doing a impdp? if so, that could be one of your problem. We really need to see the trigger text to identify the issue. Since it mentions dbms_session, it could be that you are missing privileges related to contexts? there are multiple possibilties. Please compare privileges from dba_sys_privs for the user in source and target and see what is missing. Also compare tab_privs, it could be that one of the table privs from another schema is missing? Check impdp log for reported issues as well.
I wouldnt try inserting until that trigger compiles correctly.
Raj
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 27 2013 - 18:18:27 CEST