简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

Oracle 用dblink 跨库导数据

WBOY
Release： 2016-06-07 17:03:06
Original
1075 people have browsed it

一般都会用imp exp 备份和导入数据库 但是有些时候 需要比较灵活的从两个数据库之间取数据 我这里用到的是oralc的dblink方式。首

Oracle 用dblink 跨库导数据

[日期：2011-08-02] 来源：Linux社区  作者：zhouxingfu [字体：]

一般都会用imp exp 备份和导入数据库  但是有些时候 需要比较灵活的从两个数据库之间取数据 我这里用到的是oralc的dblink方式。

首先监听器tnsnames.ora这个文件能连接到远程要创建dblink的数据库。

-- 创建dblink   MANAGER为远程数据库的用户名 password 为远程数据库的密码， orcl为监听器连好的链接名称

这样就可以连接到 orcl数据库 灵活的取每一张表的数据了

--两个数据库都存在 tb_demo表  这是本表插入

--查询数据 sql和本地一样了  只是后面加个@DDD.REGRESS.RDBMS.DEV.US.ORACLE.COM  就等于是dblink连好的远程数据库了

linux

  • 0

    • Oracle 数据大小超出此类型的最大值：2736

    Oracle 10g 建表空间 授权 ,自动备份，恢复

    ，
    Related labels：
    Oracle教程 Oracle 用dblink 跨库导数据
    source：php.cn
    Previous article：Oracle 进程结构（Process Structure） Next article：Linux下MySQL数据库安装与配置
    Statement of this Website
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
    Latest Articles by Author
    Latest Issues
    Regular expression filter for MERN stack search boxes and checkboxes I'm trying to understand how the MERN stack works together by learning by doing, and I'm f...
    From 2024-04-06 14:53:12
    0
    1
    425
    How to render data through DOM instead of through table I have a question about an application I'm creating, I'm using an Oracle database and I'm ...
    From 2024-04-04 18:17:27
    0
    1
    3567
    Prestashop installation issue: Unable to install custom module I am new to Prestashop module development. I'm trying to build Amy's first prestashop modu...
    From 2024-04-03 19:24:44
    0
    1
    402
    PHP Tutorial: How to upload text and images to Linkedin using PHP? I try to upload text, images and links using LinkedinsRestAPI (https://learn.microsoft.com...
    From 2024-04-03 18:42:29
    0
    1
    420
    Unable to receive information from my mySQL database despite having seen tutorials doing the exact same thing So I'm trying to make a program that reads and writes to a MySQL database, which led me to...
    From 2024-04-03 14:46:04
    0
    1
    298
    Related Topics
    More>
    Popular Recommendations
    Popular Tutorials
    More>
    Related Tutorials
    Popular Recommendations
    Latest courses
    Latest Downloads
    More>
    Web Effects
    Website Source Code
    Website Materials
    Front End Template
    About us Disclaimer Sitemap
    php.cn：Public welfare online PHP training，Help PHP learners grow quickly！