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
Scott, can you run this command in sqlplus and e-mail the results out to
us...
show errors trigger triggername
[EMAIL PROTECTED] 04/04/03 02:14PM
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
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
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,
Here is the output of the show errors command (which I didn't know about...
Thanks).
==
SQL show errors trigger famis_pr_status_insert
Errors for TRIGGER FAMIS_PR_STATUS_INSERT:
LINE/COL ERROR
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
There's probably many more causes for this than I am aware, but most of
the occasions when I have seen an identifier blah.blah must be
declared was when I was logged in as the wrong user trying to compile
the procedure.
[EMAIL PROTECTED] 04/04/03 04:24PM
Here is the output of the show errors
Do you have execute privs set for MAILER.DBMS_OFFICE??
Does it exist on the second database??
Is the MAILER schema on the database?
(I'm climbing my ladder of thoughts as I'd check them)
Just a thought
Rick Weiss
Helena, MT USA
-Original Message-
Sent: Friday, April 04, 2003 15:24
No, both instances were built the same way and they both worked before
this. I noticed that when I did a show errors trigger trigger_name
I saw:
=
106/32 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared
106/32 PL/SQL: Statement
To answer the previous questions:
1. No (That was the problem)
2. Yes
3. Yes
Thanks so much. It's working now. granted execute on
dbms_office to famis and that did it.
Maybe it's the fact that I'm a newbie, but I assumed the grants would
come over with the import. I think I understand what
Title: Message
Scott-
Wow -
what a way to finish a week, I actually got something right. I may have to
celebrate - looks like it's time to pull out my fly rod and attack some trout -
if it doesn't snow again tonight. ( The challenges of living in MT
)
Here's
a picture for the rest of the
/whatsnew/cam2_mcdonald.htm
Have an excellent weekend
folks
Rick Weiss
Helena, MT
-Original Message-
From: Scott Stefick
[mailto:[EMAIL PROTECTED]]
Sent: Friday, April 04, 2003 16:26
To: Multiple recipients of list ORACLE-L
Subject: RE: Importing Schema getting compilation errors on
some
12 matches
Mail list logo