Database Reference
In-Depth Information
The final step would be to copy
allobjects.dat
onto another server, perhaps a development machine for testing
with, and extract the DDL to re-create this table over there:
EODA@ORA12CR1> select dbms_metadata.get_ddl( 'TABLE', 'ALL_OBJECTS_UNLOAD' ) from dual;
DBMS_METADATA.GET_DDL('TABLE','ALL_OBJECTS_UNLOAD')
---------------------------------------------------
CREATE TABLE "EODA"."ALL_OBJECTS_UNLOAD"
( "OWNER" VARCHAR2(128),
"OBJECT_NAME" VARCHAR2(128),
"SUBOBJECT_NAME" VARCHAR2(128),
"OBJECT_ID" NUMBER,
"DATA_OBJECT_ID" NUMBER,
"OBJECT_TYPE" VARCHAR2(23),
"CREATED" DATE,
"LAST_DDL_TIME" DATE,
"TIMESTAMP" VARCHAR2(19),
"STATUS" VARCHAR2(7),
"TEMPORARY" VARCHAR2(1),
"GENERATED" VARCHAR2(1),
"SECONDARY" VARCHAR2(1),
"NAMESPACE" NUMBER,
"EDITION_NAME" VARCHAR2(128),
"SHARING" VARCHAR2(13),
"EDITIONABLE" VARCHAR2(1),
"ORACLE_MAINTAINED" VARCHAR2(1)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY "TMP"
LOCATION
( 'allobjects.dat'
)
)
This makes it rather easy to load this extract on another database, as it would simply be the following, and you are
done—the data is loaded:
EODA@ORA12CR1> insert /*+ append */ into some_table select * from all_objects_unload;
■
Starting with oracle 11
g
, you can create compressed and encrypted dump files. these features require the
enterprise edition of oracle, as well as the advanced Compression option (for compression) and the advanced Security
option (for encryption).
Note
