Not able to insert to an imported table
- From: Lu Jiang <lu.jiang69@xxxxxxxxx>
- To: list <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 27 Aug 2013 08:39:10 -0700 (PDT)
Hi all,
I am getting a strange issue. After impdp the schema of user plateau to a
target database, plateau user is not able to insert data to one of the table
owned by itself and getting the following error:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 101
ORA-06512: at "PLATEAU.PKG_STATE", line 56
ORA-06512: at "PLATEAU.PKG_STATE", line 68
ORA-06512: at "PLATEAU.PKG_QUALIFICATION", line 834
ORA-06512: at "PLATEAU.PT_AI_QUAL_CPNT", line 2
ORA-04088: error during execution of trigger 'PLATEAU.PT_AI_QUAL_CPNT'
Plateau user has been granted exact same privileges (system, role and objects)
as in the source database. Insert to this table works fine in the source
database but failed in the impdp target database.When disable the trigger in
the error message above, Insert can be completed in the target db. The packages
in the error message above are called by the trigger.
Have done some research but could not find related info. Try to submit SR
however Oracle support web site is down. Could anybody shed some light on this?
The databases are 11g.Thanks,
Lu
--
//www.freelists.org/webpage/oracle-l
Other related posts:
