Unanswered: pl/sql script tp move data from one oracle db to another
I am new to Oracle. I have to write one SQL script that moves data from one Oracle db to another oracle db on different servers. If anybody has done similar work.....pls reply to me at email@example.com.
When the source database initialization parameter GLOBAL_NAMES is set to true, the database link name must match the target database global name as it exists in the GLOBAL_NAME view in the data dictionary.
The GLOBAL_NAME can be determined by logging in to the database with system privileges and issuing the following command:
SQL>Select * from global_name;
Additionally, if you do not specify the domain portion of the dblink name in the create statement, Oracle automatically qualifies the link name with the domain of the SOURCE database global name view.
Check the contents of ALL_DB_LINKS for the fully qualified link name.