我的是从linux端向windows端迁移数据
先在linux端
SQL> conn 用户名/密码
Connected.
创建目录
SQL> create or replace directory tmp as '/tmp'
2 /
Directory created.
SQL> create table all_objects_unload
2 organization external
3 ( type oracle_datapump
4 default directory TMP
5 location( 'allobjects.dat' )
6 )
7 as
8 select * from all_objects
9 /
Table created.
查看导出的文件头部信息
SQL> !strings /tmp/allobjects.dat | head
"LYC"."U"
Linuxi386/Linux-2.0.34-8.1.0
AL32UTF8
11.02.00.00.00
001:001:000001:000001
i<?xml version="1.0"?>
1
查看表里有哪些字段
SQL> desc all_objects;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
OBJECT_NAME NOT NULL VARCHAR2(30)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NOT NULL NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(19)
CREATED NOT NULL DATE
LAST_DDL_TIME NOT NULL DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NOT NULL NUMBER
EDITION_NAME VARCHAR2(30)
查看导出的数据有多少条
SQL> select count(*) from all_objects;
COUNT(*)
----------
71566
windows端
数据完全导入
(以上参考asktom)
先在linux端
SQL> conn 用户名/密码
Connected.
创建目录
SQL> create or replace directory tmp as '/tmp'
2 /
Directory created.
SQL> create table all_objects_unload
2 organization external
3 ( type oracle_datapump
4 default directory TMP
5 location( 'allobjects.dat' )
6 )
7 as
8 select * from all_objects
9 /
Table created.
查看导出的文件头部信息
SQL> !strings /tmp/allobjects.dat | head
"LYC"."U"
Linuxi386/Linux-2.0.34-8.1.0
AL32UTF8
11.02.00.00.00
001:001:000001:000001
i<?xml version="1.0"?>
1
查看表里有哪些字段
SQL> desc all_objects;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
OBJECT_NAME NOT NULL VARCHAR2(30)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NOT NULL NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(19)
CREATED NOT NULL DATE
LAST_DDL_TIME NOT NULL DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NOT NULL NUMBER
EDITION_NAME VARCHAR2(30)
查看导出的数据有多少条
SQL> select count(*) from all_objects;
COUNT(*)
----------
71566
windows端
数据完全导入
(以上参考asktom)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30211111/viewspace-1616919/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30211111/viewspace-1616919/