Create Private Database Link

Create Private Database Link in other Schema using SYS/SYSTEM

Scenario: Create database links owned by¬†application¬†user whose credentials are not shared with DBA In Reality: For creating private database link, you will need to connect to user & then create it. If you try to create it using SYS as <owner>.<db_link_name>, Oracle will create DB LINK with name <owner>.<db_link_name> under […]