Home/Questions/Q 4463
In Process
Swarup
Swarup

Swarup

  • India
View Profile
  • 0
Professional
Asked: 2021-01-10T18:20:50+05:30

Data Exchange within database from Dev to Val

  • 0

Hi Sir,

Good Evening, Happy New Year,

I have installed Oracle Apex in One Database(Development DB) but i want to get the data from the another Database(Validation DB) where apex is not installed is it possible?

 

Thanks In Advance

data

    1 Answer

    1. Vinish

      Vinish

      View Profile
      Legendary

      You will have to create a database link to read or write to a table located in another database. Below is an example of creating a database link:

      CREATE DATABASE LINK mydblink 
CONNECT TO remote_db IDENTIFIED BY password
USING '(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=yourhost)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=yourservice_name))
)';

      Now you can select the rows from the remove database table as follows:

      Select * from myxyz@mydblink;
      • 0

    You must login to add an answer.