How Do You Create A Database Link In Oracle?
A database link allows you to connect to a remote Oracle database and access that database’s objects (like tables, columns and schemas). To refer to the objects, append the table with the “@dblink” designation. Replace “dblink” with the name given to the link. You can perform queries such as SELECT, INSERT, UPDATE, DELETE, or LOCK TABLE in the same manner as if you were accessing a local database. To create a database link, the user must have the CREATE DATABASE LINK and CREATE SESSION privileges. Access the operating system’s command prompt. Unix/Linux users must open a terminal window. Windows users must open a Command Prompt window. You will be presented with a screen where you will type the following commands. Type the command “sqlplus” to access the SQL Plus application. This application allows you to send queries to a Oracle database server. Type your user name and password when prompted for it. You will then be presented with the “SQL>” prompt where you will issue the rest of th
