Re: how to export public synonyms from one to another oracle database

"Tom" <mail_at_yahoo.com> wrote in message news:cvcle4$skh$1_at_ls219.htnet.hr...
> And script looks like???
> can you please write some example?
>
> "Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message
> news:cvcag5$iit$2_at_news3.zwoll1.ov.home.nl...
>> Don't - create a script instead.
>
>

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 Received on Mon Feb 21 2005 - 07:11:28 CST