Concepts and Architecture Question:

What is Private Database Link in Oracle?

Tweet Share WhatsApp

Answer:

Database link is created by a user in his schema,it has 2 types

1.private database link
2.public database link /global

private database link is access the object in separate user

syntax:

create database link connect to username identified by password using 'db_name';

Download Oracle Architecture and Concepts PDF Read All 82 Oracle Architecture and Concepts Questions
Previous QuestionNext Question
If a user executes a query which is already being used by a view exactly will oracle use already existing view to retrieve data or use the query executed by user?What is Data Block in Oracle Architecture?