| 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: exporting and importing public synonyms
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.=20
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 m=AA=BF=AAm
>>> 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=3DA-user touser=3DB-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
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20
Author: pascal dumas
INET: pdumas_at_ota.fr.socgen.com=20
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). Received on Wed Dec 13 2000 - 08:51:42 CST
 |
 |