Re: Not able to insert to an imported table
- From: rjamya <rjamya@xxxxxxxxx>
- To: lu.jiang69@xxxxxxxxx
- Date: Tue, 27 Aug 2013 12:18:27 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
