I need to export public synonyms from one to another oracle database.

Since public synonyms are logical objects and owner 'PUBLIC' is also logical
a can't export those
owner through exp/imp utility..
example
exp system/manager (AT) pro (DOT) proliant from user = <public>
file=public_synonims.dmp

any idea???

Tom wrote:

--
Regards,
Frank van Bortel

And script looks like???
can you please write some example?

"Frank van Bortel" <fvanbortel (AT) netscape (DOT) net> wrote

On Mon, 21 Feb 2005 13:50:17 +0100, Tom wrote:

Use the following steps to get an example:

1) start a browser such as Internet Explorer or Firefox
2) in the URL are, enter: http://www.google.com
3) in the text box enter: "oracle script to export public synonyms"
4) in the results page, select the first displayed link

Use the skills to decide when to use the enter key or submit button.

(By the way, the search resulted in about 4,760 results, the first of
which was to gennick.com/extract_synonyms.html)

lol/FGB

"Tom" <mail (AT) yahoo (DOT) com> wrote

SQL*Plus scripts, that is -- or perhaps, TOAD.

Are you familiar with the data dictionary? The idea is to write a SQL
statement that select data from the data dictionary to generate 'CREATE
PUBLIC SYNONYM' SQL statements, save the generated statements to a file (the
script file), and then execute the script file in the new environment.

You can automate this to a degree with the SQL*Plus SPOOL command and other
formatting commands, are just cut and paste the results of your query into a
file.

Have you used SQL*Plus or TOAD?

++ mcs

so funny!!!! thanks anyway!!


"GreyBeard" <Fuzzy.GreyBeard (AT) gmail (DOT) com> wrote

yes, t.o.a.d is the best tool for running queries..and lot's of other
things...
i "copy" synonyms from one database to other, by writing my own script...

"Mark C. Stock" <mcstockX@Xenquery .com> wrote