-
synonym for db links
can we create synonym for database links? if yes what is the syntax and procedure..
J Gangadhar
-
i tried before on 8i but unfortunately cannot.. donno on 9i or 10g can or not.
The man called Zorro
-
AFAIK you cannot have synonyms for dblinks.
Srini
-
since when you cannot have synonyms for db links?!
-
sorry guys my fault, gave a wrong dblinkname and tried, just now realised it.
pando, if i create a synonym for dblink then how do i specify my sql.
select * from xyz@synonynname
is the above stmt right?
Srini
-
keep waiting;
pando will try and answer you.
why can't you try ?
-
SQL> create public synonym dumbass for remote_schema.dumbass@db_link_name;
This way you are creating a synonym locally for the remote table that you are accessing through the db_link.
Get it?
MH
I remember when this place was cool.
-
Originally posted by Mr.Hanky
SQL> create public synonym dumbass for remote_schema.dumbass@db_link_name;
This way you are creating a synonym locally for the remote table that you are accessing through the db_link.
Get it?
MH
Yea, This one will work.. Tried before as well...
The man called Zorro
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|