Database Links for Roles?
I have about 10 schemas that have to be able to see the same objects in a schema on another instance.
I don't fancy creating a separate DB link for each schema, so I was wondering if it's possible to create a role and create the database link for that role.
Is this possible? The create database link syntax seems to suggest that links are only applicable to schemas.
Last edited by Peer Jones; 07-20-2006 at 08:29 AM.
no, the database needs to have a username and password to connect to
OK, Davey, thanks anyway.
Click Here to Expand Forum to Full Width