"Frank van Bortel" <fvanb...@netscape.net> wrote in message
news:cvcag5$iit$2...@news3.zwoll1.ov.home.nl...
> Don't - create a script instead.
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/man...@pro.proliant from user = <public>
file=public_synonims.dmp
any idea???
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
>
> And script looks like???
> can you please write some example?
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
--
Regards,
Frank van Bortel
"GreyBeard" <Fuzzy.G...@gmail.com> wrote in message
news:pan.2005.02.21....@gmail.com...
"Mark C. Stock" <mcstockX@Xenquery .com> wrote in message
news:zY6dnaVvbtK...@comcast.com...