Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Importing Schema getting compilation errors on some
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 world to see - I love it here. http://www.nps.gov/glac/whatsnew/cam2_mcdonald.htm <http://www.nps.gov/glac/whatsnew/cam2_mcdonald.htm>
Have an excellent weekend folks
Rick Weiss
Helena, MT
-----Original Message-----
Sent: Friday, April 04, 2003 16:26
To: Multiple recipients of list ORACLE-L
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).
LINE/COL ERROR
-------- ----------------------------------------------------------------- 106/32 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 106/32 PL/SQL: Statement ignored
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
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
<http://www.orafaq.net/>
>--
>Author: Scott Stefick
> INET: sstefick_at_harpercollege.edu
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<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
<http://www.orafaq.net/>
>--
>Author: Darrell Landrum
> INET: DLANDRUM_at_zalecorp.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<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 <http://www.orafaq.net/> -- Author: Scott Stefick INET: sstefick_at_harpercollege.edu Fat City Network Services -- 858-538-5051 http://www.fatcity.com <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 <http://www.orafaq.net/> -- Author: Weiss, Rick INET: rweiss_at_state.mt.us Fat City Network Services -- 858-538-5051 http://www.fatcity.com <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: 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 - 17:43:44 CST