I saw:
=====================================================
106/32 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared
106/32 PL/SQL: Statement ignored
=====================================================
I'm checking why this would have happened. So far I've checked the synonyms and the dba_objects view and they look ok.
-Scott
At 01:59 PM 4/4/03 -0800, you wrote:
Scott:
My first thought is to ask if there are any external references (other schemas, SYS packages, etc.) in the triggers that may not exist in TRAIN that do exist in TEST
Rick Weiss
-----Original Message----- Sent: Friday, April 04, 2003 13:14 To: Multiple recipients of list ORACLE-L
Hello,
Oracle 8.1.7.4 HPUX 11.11 App is Famis Maintenance Management System
I have 3 instances TEST, TRAIN, PROD and I am trying to refresh the whole "famis" schema on TRAIN with the "famis" schema on TEST. Every time I try to do the import, I get compilation errors for 4 triggers (out of 75). I tried to re-compile them in the TRAIN instance after the import and get the same compilation errors. I try to re-compile them in TEST which is where they came from and they compile without a problem. I don't understand why this would happen when I exported the whole schema from TEST and imported the whole .dmp file into TRAIN.
Any Thoughts?
-Scott
************************************** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ************************************** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
************************************** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ************************************** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
