Importing Schema getting compilation errors on some triggers

2003-04-04 Thread Scott Stefick
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

Re: Importing Schema getting compilation errors on some triggers

2003-04-04 Thread Stephane Faroult
Scott Stefick wrote: 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

RE: Importing Schema getting compilation errors on some triggers

2003-04-04 Thread Weiss, Rick
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,

RE: Importing Schema getting compilation errors on some triggers

2003-04-04 Thread Kirsh, Gary
Maybe the triggers reference objects in a different schema? Gary -Original Message- Sent: Friday, April 04, 2003 3:14 PM 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