RE: TRIGGER:... created with compilation warnings ?... Basic Qs
Date: Thu, 24 Apr 2008 15:34:27 -0400
Message-ID: <21469B88E0EA11498818517F2103353101C662A3@EPRI17P32001A.csfb.cs-group.com>
select line, position, text from dba_errors where owner='CRMUSER' and
name='TRG_LCT' and type='TRIGGER'
order by sequence, line, position;
Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA
Sent: Thursday, April 24, 2008 3:26 PM
To: oracle-l_at_freelists.org
Subject: TRIGGER:... created with compilation warnings ?... Basic Qs
Folks
Following Error Occurred during impdp:-
ORA-39082: Object type TRIGGER:"CRMUSER"."TRG_LCT" created with compilation warnings
ACTION:- SQL> alter trigger "CRMUSER"."TRG_LCT" compile;
Warning: Trigger altered with compilation errors.
SQL> show errors
No errors.
Qs What is the approach for further diagnostics/resolution of this error?
Cheers & Thanks
Vivek
- CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this
e-mail or its contents to any other person and any such actions are
unlawful. This e-mail may contain viruses. Infosys has taken every
reasonable precaution to minimize this risk, but is not liable for any
damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 24 2008 - 14:34:27 CDT