---
title: "在项目中使用dblink"
author: "java_frog"
date: "2012-02-29T16:39:36Z"
tags: []
categories: ["数据库"]
slug: "dblink"
draft: false
lastmod: "2012-02-29T16:39:36Z"
id: 1432007
url: "https://java-frog.iteye.com/blog/1432007"
---

今天试了一下oracle dblink,确实挺方便的。
首先本地要配了远程服务名；接下来创建dblink；最后建同义词，使得访问远程表跟本地一样。
创建dblink:

```java
CREATE database link a connect to newdbzq identified by newdbzq using 'db61';
```

建同义词：

```java
create public synonym user_basic_info for user_basic_info@a ;
```

访问本地一样访问

```java
select * from user_basic_info
```