--数据泵卸载
用外部表把数据库中的数据卸载到文件系统。
--模拟实验数据泵卸载再在新环境中插入
EODA@PROD1> create or replace directory tmp as '/tmp';
Directory created.
EODA@PROD1> set echo on
EODA@PROD1> create table all_objects_unload
2 organization external
3 ( type oracle_datapump --数据泵
4 default directory TMP
5 location( 'allobjects.dat' ) --定义路径
6 )
7 as
8 select
9 *
10 from all_objects
11 /
Table created.
EODA@PROD1>
EODA@PROD1> select dbms_metadata.get_ddl( 'TABLE', 'ALL_OBJECTS_UNLOAD' ) --查看建表语句
2 from dual;
DBMS_METADATA.GET_DDL('TABLE','ALL_OBJECTS_UNLOAD')
--------------------------------------------------------------------------------
CREATE TABLE "EODA"."ALL_OBJECTS_UNLOAD"
( "OWNER" VARCHAR2(30),
"OBJECT_NAME" VARCHAR2(30),
"SUBOBJECT_NAME" VARCHAR2(30),
&