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_at_Xenquery .com> wrote in message
news:zY6dnaVvbtKVQ4TfRVn-uA_at_comcast.com...
>
> "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 Tue Feb 22 2005 - 03:00:54 CST
