这是tom的深入数据库体系结构的例子,学习了
备份表到外部文件
create table gftuser
organization external
(type oracle_datapump
default directory tmp
location('test0801.dmp')
)
as
select * from all_objects
从外部文件到数据库
create table t
( owner varchar2(30),
object_name varchar2(30),
subobject_name varchar2(30),
object_id number,
data_object_id number,
object_type varchar2(19),
created date,
last_ddl_time date,
timestamp varchar2(19),
status varchar2(7),
temporary varchar2(1),
generated varchar2(1),
secondary varchar2(1)
)
organization external
( type oracle_datapump
default directory tmp
location( 'test0801.dmp' )
)
，