-
Hi All
I have created a privte db alink on scott user of my local machine using 'CURRENT_USER' clause.
CREATE DATABASE LINK GDB
CONNECT TO CURRENT_USER
USING 'GEODB'
When from SCOTT I run 'select * from emp@gdb' then it creates problem. It gives the error above (in sbject line)
The link works fine I remove the CONNECT TO line.
Whats the problem with the CONNECT_USER clause here. One link on Oracle club says that it may be because of you have installed Advance Security Option. Does it like that? How then I will use CURRENT_USER clause.
Amol
-
Refer Doc #158365.1 on metalink.
You can't have the CURRENT_USER clause in a dblink if the db where the link resides uses the ASO.
-amar
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
|