| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Importing Schema getting compilation errors on some
To answer the previous questions:
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
> >
> > >>> sstefick_at_harpercollege.edu 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: 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: Darrell Landrum
> > INET: DLANDRUM_at_zalecorp.com
> >
> >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).
>
>
>**************************************
>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).
-- 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).Received on Fri Apr 04 2003 - 17:26:00 CST
 |
 |