Skip navigation
ANNOUNCEMENT: community.oracle.com is currently Read only due to planned upgrade until 29-Sep-2020 9:30 AM Pacific Time. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.

CREATE easily Database Link for another user

score 550
You have not voted. Active

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

Comments

Vote history