I agree with having to celebrate, since I was able to accomplish my task before I left for the weekend. That's always a good thing. Have a good weekend as well and good luck with the weather and the fishing.
-Scott
At 03:43 PM 4/4/03 -0800, you wrote:
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
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
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 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 **************************************
**************************************
Scott Stefick
Systems / Oracle Certified DBA
Wm. Rainey Harper College
847.925.6130
**************************************
