Generally, impexp is used to back up and import the database, but sometimes it is necessary to flexibly retrieve data from the two databases. Here I am using the dblink method of or1c. First
Generally, imp exp is used to back up and import data to the database. However, in some cases, it is necessary to flexibly retrieve data from two databases. Here I use the dblink method of or1c. First
Oracle uses dblink to export data across Databases
[Date: 2011-08-02] Source: Linux community Author: zhouxingfu [Font:]
Generally, imp exp is used to back up and import data to the database. However, in some cases, it is necessary to flexibly retrieve data from two databases. Here I use the dblink method of or1c.
First, the listener tnsnames. ora file can be connected to the database where you want to create dblink remotely.
-- Create dblink MANAGER as the remote database Username password as the remote database password, orcl as the listener connection name
In this way, you can connect to the orcl database to flexibly retrieve the data of each table.
-- Both databases have the tb_demo table. This table is inserted.
-- The SQL statement for data query is the same as that for the local database. Only @ DDD. REGRESS. RDBMS. DEV. US. ORACLE. COM is added to the SQL statement, which is equivalent to the remote database connected by dblink.
0
Oracle data size exceeds the maximum value of this type: 2736
Oracle 10g tablespace creation authorization, automatic backup, recovery
,