Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

1,090 views
Skip to first unread message

Tom

unread,
Feb 21, 2005, 7:50:17 AM2/21/05
to
And script looks like???
can you please write some example?

"Frank van Bortel" <fvanb...@netscape.net> wrote in message
news:cvcag5$iit$2...@news3.zwoll1.ov.home.nl...
> Don't - create a script instead.


Tom

unread,
Feb 21, 2005, 3:25:59 AM2/21/05
to
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/man...@pro.proliant from user = <public>
file=public_synonims.dmp

any idea???


Mark C. Stock

unread,
Feb 21, 2005, 8:11:28 AM2/21/05
to

"Tom" <ma...@yahoo.com> wrote in message news:cvcle4$skh$1...@ls219.htnet.hr...

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


GreyBeard

unread,
Feb 21, 2005, 8:09:25 AM2/21/05
to
On Mon, 21 Feb 2005 13:50:17 +0100, Tom wrote:

>
> 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

Frank van Bortel

unread,
Feb 21, 2005, 4:45:38 AM2/21/05
to
Don't - create a script instead.

--
Regards,
Frank van Bortel

Tom

unread,
Feb 22, 2005, 3:55:49 AM2/22/05
to
so funny!!!! thanks anyway!!


"GreyBeard" <Fuzzy.G...@gmail.com> wrote in message
news:pan.2005.02.21....@gmail.com...

Tom

unread,
Feb 22, 2005, 4:00:54 AM2/22/05
to
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 in message
news:zY6dnaVvbtK...@comcast.com...

0 new messages