Oracle的外部表,或者备份单个表到外部文件__VARCHAR2_directory_external_NUMBER_create_

当前位置: 数据库>oracle

Oracle的外部表,或者备份单个表到外部文件

来源: 互联网发布时间：2017-04-17

本文导语: 这是Tom的深入数据库体系结构的例子,学习了备份表到外部文件 create table gftuserorganization external(type Oracle_datapumpdefault directory tmplocation('test0801.dmp'))as select * from all_objects 从外部文件到数据库 create table t( OWNER VARCHAR2(30),OBJECT_NAME VA...

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