What is Data instantiation
...
The output should indicate there are no tables in the REPOE schema in the target database.
Create the Database Link
A database link is a schema object in one database that enables you to access objects on another database. After you have created a database link, you can use it to refer to tables and views on the other database. Oracle Datapumps use the database link to gather the data from remote database - in our example from source database and insert them to target database.
The APPLY.sh script created by the Setup Wizard for instantiating the target schema using DataPump export/import over a database link. This database link must be created for the script to work.
...
3. On the source server, as oracle, in the $HOME/replicate directory, execute the APPLY.sh script. This script will take approximately 3 - 9 minutes to complete depending on your host machine.
| No Format |
|---|
cd $HOME/replicate ./APPLY.sh |
...
On the source machine, as oracle, in the $HOME/replicatescripts directory, execute the record_count.bash script to check the record counts between the two databases.
...