This is an example of Tom's in-depth database architecture. He has learned how to back up a table to an external file createtablegftuserorganizationexternal (typeOracle_datapump
This is an example of Tom's in-depth database architecture. He has learned how to back up a table to an external file create table gftuserorganization external (type Oracle_datapump
This is an example of Tom's in-depth database architecture.
Back up a table to an external file
Create table gftuser
Organization external
(Type Oracle_datapump
Default directory tmp
Location ('test0801. dmp ')
)
As
Select * from all_objects
From external files to databases
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 ')
)
,