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 happened now. The grants on the objects that "famis" owns come over with the import, not any of the grants for objects outside of that schema. I think about it now and I'm like "Damn that makes total sense!" I don't know why I assumed that famis would get the grants from all of the other objects, that "doesn't make sense to me now".
Rick, if you're ever in the Chicago area, I'll have to buy you a beer (or whatever you prefer).
Also, thanks to everyone who helped me.
Rick Weiss
Darrell Landrum
Stephane Faroult
Gary Kirsh
Charlie Mengler
Thanks!
-Scott
At 02:53 PM 4/4/03 -0800, you wrote:
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
To: Multiple recipients of list ORACLE-L
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
-------- -----------------------------------------------------------------
106/32 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared
106/32 PL/SQL: Statement ignored
180/32 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared
180/32 PL/SQL: Statement ignored
SQL>
SQL> show errors trigger famis_req_insert
Errors for TRIGGER FAMIS_REQ_INSERT:
LINE/COL ERROR
-------- -----------------------------------------------------------------
187/21 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared
187/21 PL/SQL: Statement ignored
264/25 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared
264/25 PL/SQL: Statement ignored
339/25 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared
339/25 PL/SQL: Statement ignored
416/24 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared
416/24 PL/SQL: Statement ignored
SQL>
=========================================================================
I'm guessing it's a problem with DBMS_OFFICE and not with the trigger after
seeing this.
-Scott
At 01:43 PM 4/4/03 -0800, you wrote:
>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
>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: Darrell Landrum
> 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).
--
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
**************************************
