Oracle的外部表格,或者備份單個表到外部檔案

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