Every time I am asked to create a link to another DB schema is the same headache. Sometimes I use the dbms_sys_sql.parse_as_user to execute the create code as the other user. I need to give the user the CREATE DATABASE LINK system privilege, execute the action and than revoke it back. Things get even worse when I'm on a Database Vault enabled DB.
Why Oracle does not simplify the things with a SYNTAX like:
CREATE DATABASE LINK SCOOT.TMP_LINK ......
Please Oracle, give me that syntax! =]
Regards,
Rodrigo Jorge