RE: Importing Schema getting compilation errors on some triggers

From: Weiss, Rick <rweiss_at_state.mt.us>
Date: Fri, 04 Apr 2003 13:59:29 -0800
Message-ID: <F001.0057AEE9.20030404135929@fatcity.com>

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: sstefick_at_harpercollege.edu

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: ListGuru_at_fatcity.com (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: rweiss_at_state.mt.us

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: ListGuru_at_fatcity.com (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). Received on Fri Apr 04 2003 - 15:59:29 CST