RETAIL库所在的机器为IBM3
SCOTT@RETAIL>CREATE TABLE EMP_20100525 AS SELECT * FROM EMP;
Table created.
Elapsed: 00:00:00.11
SCOTT@RETAIL>select count(*) from EMP_20100525;
COUNT(*)
----------------
12
Elapsed: 00:00:00.00
SCOTT@RETAIL>delete from EMP_20100525 where rownum = 1;
1 row deleted.
Elapsed: 00:00:00.00
SCOTT@RETAIL>commit;
Commit complete.
Elapsed: 00:00:00.00
SCOTT@RETAIL>SELECT * FROM EMP_20100525;
EMPNO ENAME JOB MGR HIREDATE SAL
---------------- ---------- --------- ---------------- ------------------- ---------------- --------
7566 JONES MANAGER 7839 1981-04-02 00:00:00 2975
7654 MARTIN SALESMAN 7698 1981-09-28 00:00:00 1250
7698 BLAKE MANAGER 7839 1981-05-01 00:00:00 2850
7782 CLARK MANAGER 7839 1981-06-09 00:00:00 2450
7788 SCOTT ANALYST 7566 1987-04-19 00:00:00 3000
7839 KING PRESIDENT 1981-11-17 00:00:00 5000
7844 TURNER SALESMAN 7698 1981-09-08 00:00:00 1500
7876 ADAMS CLERK 7788 1987-05-23 00:00:00 1100
7900 JAMES CLERK 7698 1981-12-03 00:00:00 950
7902 FORD ANALYST 7566 1981-12-03 00:00:00 3000
7934 MILLER CLERK 7782 1982-01-23 00:00:00 1300
11 rows selected.
Elapsed: 00:00:00.01
testdb 所在的库为IBM6
NCV31@testdb>create database link to29_scott connect to scott identified by "1" using 'RETAIL';
Database link created.
Elapsed: 00:00:00.05
NCV31@testdb>set line 80;
NCV31@testdb>desc emp_20100525@to29_scott
Name Null? Type
----------------------------------------- -------- ----------------------------
EMPNO NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(2)
现在IBM6上,把刚才在IBM3上,RETAIL库里新建的EMP_20100525表导出来
ibm6 ->expdp ncv31/1 dumpfile=emp_2010525_to29_scott.dmp logfile=emp_2010525_to29_scott.log network_link=to29_scott tables=emp_20100525
Export: Release 10.2.0.4.0 - 64bit Production on Tuesday, 25 May, 2010 15:49:11
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "NCV31"."SYS_EXPORT_TABLE_01": ncv31/******** dumpfile=emp_2010525_to29_scott.dmp logfile=emp_2010525_to29_scott.log network_link=to29_scott tables=emp_20100525
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "SCOTT"."EMP_20100525" 7.710 KB 11 rows
Master table "NCV31"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for NCV31.SYS_EXPORT_TABLE_01 is:
/rmanbak/expdp/emp_2010525_to29_scott.dmp
Job "NCV31"."SYS_EXPORT_TABLE_01" successfully completed at 15:49:18
ibm6 ->