Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Importing Schema getting compilation errors on some

RE: Importing Schema getting compilation errors on some

From: Scott Stefick <sstefick_at_harpercollege.edu>
Date: Fri, 04 Apr 2003 16:43:36 -0800
Message-ID: <F001.0057B231.20030404164336@fatcity.com>


Rick,

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>http://www.nps.gov/glac
>/whatsnew/cam2_mcdonald.htm
>
>Have an excellent weekend folks
>
>Rick Weiss
>Helena, MT
>>-----Original Message-----
>>From: Scott Stefick [mailto:sstefick_at_harpercollege.edu]
>>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
>>> >
>>> > >>> 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).
>>
>>
>>**************************************
>>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
>**************************************

-- 
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 - 18:43:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US