Yes David. The following are the lines pointed by the error message:  BEGIN   DBMS_SESSION.SET_CONTEXT(get_context_name, 'DB_TIMEZONE', tz); END; â¦â¦ BEGIN  v_db_timezone := SYS_CONTEXT(get_context_name, 'DB_TIMEZONE');  IF (v_db_timezone IS NULL) THEN    v_db_timezone := pkg_tool.get_db_timezone;    set_db_timezone(v_db_timezone);  END IF;  RETURN v_db_timezone; END;  Could you please advise on what should I do to fix this?  Thanks, Lu   ________________________________ From: "david@xxxxxxxxxxxxxxxxxxxx" <david@xxxxxxxxxxxxxxxxxxxx> To: lu.jiang69@xxxxxxxxx; Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx> Cc: list <oracle-l@xxxxxxxxxxxxx> Sent: Tuesday, August 27, 2013 12:19 PM Subject: Re: Not able to insert to an imported table So, from what I can tell, DBMS_SESSION is probably calling SET_CONTEXT. The CONTEXT in question probably doesn't exist on the new system. This is leading to the error. Cheers, David -----Original Message----- From: Lu Jiang Sent: Tuesday, August 27, 2013 5:05 PM To: Toon Koppelaars Cc: list Subject: Re: Not able to insert to an imported table granted execute on dbms_session to the user did not help, even granted dba role did not help. Thanks, Lu ________________________________ From: Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx> To: lu.jiang69@xxxxxxxxx Cc: list <oracle-l@xxxxxxxxxxxxx> Sent: Tuesday, August 27, 2013 11:48 AM Subject: Re: Not able to insert to an imported table Looks like you are missing a direct (ie. not via role) execute privilige on dbms_session... On Tue, Aug 27, 2013 at 5:39 PM, Lu Jiang <lu.jiang69@xxxxxxxxx> wrote: 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 > > > -- Toon Koppelaars RuleGen BV Toon.Koppelaars@xxxxxxxxxxx http://www.rulegen.com/ TheHelsinkiDeclaration.blogspot.com (co)Author: "Applied Mathematics for Database Professionals" www.rulegen.com/am4dp-backcover-text -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l