RE: Not able to insert to an imported table
Date: Tue, 27 Aug 2013 15:45:05 +0000
Message-ID: <D18D6513433DF04394041EA42B53E91C9CE011CA_at_ICATMAIL1.ICAT.com>
What does the trigger attempt to do? If disabling the trigger allows the insert to complete, I would dig down into what the trigger is trying to accomplish.
-joe
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lu Jiang
Sent: Tuesday, August 27, 2013 9:39 AM
To: list
Subject: Not able to insert to an imported table
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
--
http://www.freelists.org/webpage/oracle-l
Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT Managers, LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 27 2013 - 17:45:05 CEST