Skip to Main Content

SQL & PL/SQL

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!

create or replace synonym ... how to execute the script.

183703Mar 21 2007 — edited Mar 21 2007
I have the scripts that creates synonyms and i need to execute these scripts from SQL Plus.
I want to pass the &owner_user value as an argument, but the script still comes back and asking for the owner_name.

create or replace synonym V_REPORTS_USAGE for &owner_user..V_REPORTS_USAGE;

create or replace synonym V_STATION_USAGE for &owner_user..V_STATION_USAGE;

How do i execute these scripts.

Thanks
-Prasad
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2007
Added on Mar 21 2007
4 comments
748 views