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: exporting and importing public synonyms

Re: exporting and importing public synonyms

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Wed, 13 Dec 2000 16:10:25 -0000
Message-Id: <10709.124445@fatcity.com>


I believe the problem comes in in 8.1.6 because you can create stored procedures to be run with "invoker's rights" rather than "creator's rights" so you can have problems with the objects you reference.

On the other hand, I've never created a procedure with invoker's rights so I might be talking nonsense :)

>From: "Ron Rogers" <RROGERS_at_galottery.org>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: exporting and importing public synonyms
>Date: Wed, 13 Dec 2000 06:55:28 -0800
>
>It is perfectly clear that you can have problems when you import synonyms
>from one user to another or database to another. The naming conventions for
>tables, views,etc are standard. table "statename" would most likely be
>"statename" in both databases.
>I would use a select statement to gather the information from dba_synonyms
>from each database and then visually "see" what the synonym names are and
>then make the decission what to do about the duplicates. Be mindfull that
>some application may need to be changed to have the correcly named synonym
>refferenced if you change some of the synonym names.
>ROR mm
>
> >>> pdumas_at_ota.fr.socgen.com 12/13/00 09:01AM >>>
>Hi,
>
>I have created some public synonyms for tables belonging to a A-user in
>a database.
>I'd like to export these synonyms and import them in another database,
>where I have
>made an import " fromuser=A-user touser=B-user ".
>
>in the Oracle 8.1.6 Documentation, they say one must be careful when
>exporting compiled objects that reference a name used as a synonym and
>as another object. But they don't say what to do in this case !!!
>
>Would anybody have had the same problem ?
>
>
>Thanks,
>
>Pascal
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: pascal dumas
> INET: pdumas_at_ota.fr.socgen.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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.com
>--
>Author: Ron Rogers
> INET: RROGERS_at_galottery.org
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).



Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com Received on Wed Dec 13 2000 - 10:10:25 CST

Original text of this message

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