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')
)