Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dynamic create synonym script

178210May 21 2005 — edited May 21 2005

we want to create few synonyms dynamicalyy, (ie) we will aceept the owner Name,DB link Names as parameter

(ex) I need to create dynamic statement

create synonym A.ATAB FOR B.ATAB@link1

while i execute the statement as

create synonym A.ATAB FOR &OWNER||".ATAB@"||&DBLINK

it gives an error saying that
SQL command not properly ended

what is wrong?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 18 2005

Added on May 21 2005

#general-database-discussions

3 comments

617 views