Oracle uses dblink to export data across Databases

Source: Internet
Author: User
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

    ,

    Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.