oracle datapump
oracle提供一个很好用的数据unloading和loading方法：oracle_datapump Access Driver, 废话不多说，方法简单，例子如下:
1.创建工作目录对象：
create directory admin_dir as '/home/oracle';
2.创建要unloading的表:
create table my_objects as select * from all_objects;
3.创建unloading外部表：
create table my_objects_unload
organization external
(
type
oracle_datapump
default directory admin_dir
location
('my_objects.dmp')
)
as
select owner,object_name,object_type
from my_objects;
drop table my_objects_unload;
4.装载/home/oracle/my_objects.dmp文件：
create table my_objects_load(
owner varchar2(30),
object_name varchar2(30),
object_type varchar2(19))
organization external
(
type oracle_datapump
default
directory admin_dir
location ('my_objects.dmp')
)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12554513/viewspace-667030/ ，如需转载，请注明出处，否则将追究法律责任。
