APPS DBA MATERIAL: DATAPUMP?

Diasadvantages with normal export and import:-

1)we cannot monitor export/import because specifying job_name is not possible.

2)we cant pause and resume export/import operations.In order to overcome this disadvantages datapump comes.

Datapump will perform export and import operations much faster than traditional ones.
whenever we go for datapump 2 background process will be done:-
1)master background process.[DM(datapump master)]
2)worker background process.[DW(datapump worker)]
1)master background process:-
It will create a master table with job_name in that particular users schema.
It will monitor entire status of that export/import operation of particular job.
After export/import done table will be dropped automatically.

2)worker background process:-
It will be created by master background process.
The entire export/import operation will be done by worker background process.

In order to perform datapump export and import we need to create the directory structure both at the physical level and logical level.Datapump jobs are served at the server side and these jobs will occupy some space in SGA. streams_pool_size is the view to know the occupied space in SGA.

if a job takes 8 hours to complete and it finished in one hour and then stopped.using traditional export we cant go with the continuation of the job but using expdp we can run the job from the particular point by using unique jobid ('job_id=----')

we will create a directory to keep the datapump jobs and logfiles & dumpfiles information.we can create the dumpfiles in this directory.

Datapump jobs can be parallely executed.

SQL> sho parameter streams_pool;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size big integer 0 (we need to assign memory to this.)
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@appsdb exp]$ vi $ORACLE_HOME/dbs/init$ORACLE_SID.ora
[oracle@appsdb exp]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 31 16:04:20 2016

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> startup force
ORACLE instance started.

Total System Global Area 283967488 bytes
Fixed Size 2212576 bytes
Variable Size 226495776 bytes
Database Buffers 50331648 bytes
Redo Buffers 4927488 bytes
Database mounted.
Database opened.

SQL> show parameter streams_pool;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size big integer 72M
SQL> select * from dba_directories;

OWNER DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS ORACLE_OCM_CONFIG_DIR
/u01/app/oracle/product/11.2.0/ccr/state

SYS DATA_PUMP_DIR
/u01/app/oracle/product/11.2.0/rdbms/log/

SQL> create directory dpump as '/u01/app/oracle/dpump';

Directory created.

SQL> select * from dba_directories;

OWNER DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS ORACLE_OCM_CONFIG_DIR
/u01/app/oracle/product/11.2.0/ccr/state

SYS DPUMP
/u01/app/oracle/dpump

SYS DATA_PUMP_DIR
/u01/app/oracle/product/11.2.0/rdbms/log/

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@appsdb exp]$ cd
[oracle@appsdb ~]$ cd /u01/app/oracle
[oracle@appsdb oracle]$ ls
arch control.ctl diag exp oraInventory product redo1a.log redo2a.log roomone.dbf sysaux.dbf system1.dbf system.dbf tempx.dbf undotbs.dbf userdata.dbf
[oracle@appsdb oracle]$ mkdir dpump
[oracle@appsdb oracle]$ ls
arch diag exp product redo2a.log sysaux.dbf system.dbf undotbs.dbf
control.ctl dpump oraInventory redo1a.log roomone.dbf system1.dbf tempx.dbf userdata.dbf
[oracle@appsdb oracle]$ cd dpump

[oracle@appsdb dpump]$ expdp directory=dpump dumpfile=datapump.dmp logfile=dp.log job_name=dp_full_1 full=y

here expdp refers to export datapump.
impdp refers to import datapump.
Export: Release 11.2.0.1.0 - Production on Wed Aug 31 16:34:24 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."DP_FULL_1": /******** AS SYSDBA directory=dpump dumpfile=datapump.dmp logfile=dp.log job_name=dp_full_1 full=y
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 592 KB
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/CONTEXT
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/AUDIT
. . exported "ABC"."DEPT" 6.007 KB 7 rows
. . exported "ABC"."DUMMY" 5 KB 1 rows
. . exported "ABC"."EMP" 8.562 KB 14 rows
. . exported "ABC"."SALGRADE" 5.859 KB 5 rows
. . exported "XYZ"."DEPT" 6.007 KB 7 rows
. . exported "XYZ"."DUMMY" 5 KB 1 rows
. . exported "XYZ"."EMP" 8.562 KB 14 rows
. . exported "XYZ"."SALGRADE" 5.859 KB 5 rows
. . exported "SYSTEM"."REPCAT$_AUDIT_ATTRIBUTE" 6.328 KB 2 rows
. . exported "SYSTEM"."REPCAT$_OBJECT_TYPES" 6.882 KB 28 rows
. . exported "SYSTEM"."REPCAT$_RESOLUTION_METHOD" 5.835 KB 19 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_STATUS" 5.484 KB 3 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_TYPES" 6.289 KB 2 rows
. . exported "OUTLN"."OL$" 0 KB 0 rows
. . exported "OUTLN"."OL$HINTS" 0 KB 0 rows
. . exported "OUTLN"."OL$NODES" 0 KB 0 rows
. . exported "SYSTEM"."DEF$_AQCALL" 0 KB 0 rows
. . exported "SYSTEM"."DEF$_AQERROR" 0 KB 0 rows
. . exported "SYSTEM"."DEF$_CALLDEST" 0 KB 0 rows
. . exported "SYSTEM"."DEF$_DEFAULTDEST" 0 KB 0 rows
. . exported "SYSTEM"."DEF$_DESTINATION" 0 KB 0 rows
. . exported "SYSTEM"."DEF$_ERROR" 0 KB 0 rows
. . exported "SYSTEM"."DEF$_LOB" 0 KB 0 rows
. . exported "SYSTEM"."DEF$_ORIGIN" 0 KB 0 rows
. . exported "SYSTEM"."DEF$_PROPAGATOR" 0 KB 0 rows
. . exported "SYSTEM"."DEF$_PUSHED_TRANSACTIONS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_AUDIT_COLUMN" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_COLUMN_GROUP" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_CONFLICT" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_DDL" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_EXCEPTIONS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_EXTENSION" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_FLAVORS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_FLAVOR_OBJECTS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_GENERATED" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_GROUPED_COLUMN" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_INSTANTIATION_DDL" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_KEY_COLUMNS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_OBJECT_PARMS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_PARAMETER_COLUMN" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_PRIORITY" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_PRIORITY_GROUP" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_REFRESH_TEMPLATES" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_REPCAT" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_REPCATLOG" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_REPCOLUMN" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_REPGROUP_PRIVS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_REPOBJECT" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_REPPROP" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_REPSCHEMA" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_RESOLUTION" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_RESOLUTION_STATISTICS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_RESOL_STATS_CONTROL" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_RUNTIME_PARMS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_SITES_NEW" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_SITE_OBJECTS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_SNAPGROUP" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_PARMS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_SITES" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_TARGETS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_USER_PARM_VALUES" 0 KB 0 rows
. . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE" 0 KB 0 rows
Master table "SYS"."DP_FULL_1" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.DP_FULL_1 is:
/u01/app/oracle/dpump/datapump.dmp
Job "SYS"."DP_FULL_1" successfully completed at 16:35:52

[oracle@appsdb dpump]$ ls
datapump.dmp dp.log
[oracle@appsdb dpump]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 31 16:36:41 2016

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select username,default_tablespace from dba_users;

USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
ORACLE_OCM USERDATA
DBSNMP SYSAUX
DIP USERDATA
APPQOSSYS SYSAUX
SYSTEM SYSTEM
SYS SYSTEM
OUTLN SYSTEM
XYZ USERDATA
ABC ROOM

9 rows selected.

SQL> conn xyz/xyz
Connected.
SQL> sho user;
USER is "XYZ"
SQL> select * from tab;

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
DEPT TABLE
DUMMY TABLE
EMP TABLE
SALGRADE TABLE

SQL> conn / as sysdba
Connected.
SQL> drop user xyz cascade;

User dropped.

SQL> select username,default_tablespace from dba_users;

USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
ORACLE_OCM USERDATA
DBSNMP SYSAUX
DIP USERDATA
APPQOSSYS SYSAUX
SYSTEM SYSTEM
SYS SYSTEM
OUTLN SYSTEM
ABC ROOM

8 rows selected.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@appsdb dpump]$ impdp directory=dpump dumpfile=datapump.dmp schemas=xyz job_name=dp_full_1

Import: Release 11.2.0.1.0 - Production on Wed Aug 31 16:39:56 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."DP_FULL_1" successfully loaded/unloaded
Starting "SYS"."DP_FULL_1": /******** AS SYSDBA directory=dpump dumpfile=datapump.dmp schemas=xyz job_name=dp_full_1
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "XYZ"."DEPT" 6.007 KB 7 rows
. . imported "XYZ"."DUMMY" 5 KB 1 rows
. . imported "XYZ"."EMP" 8.562 KB 14 rows
. . imported "XYZ"."SALGRADE" 5.859 KB 5 rows
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
Job "SYS"."DP_FULL_1" successfully completed at 16:40:08

[oracle@appsdb dpump]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 31 16:40:17 2016

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> conn xyz/xyz
Connected.
SQL> select * from tab;

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
DEPT TABLE
DUMMY TABLE
EMP TABLE
SALGRADE TABLE

SQL> conn / as sysdba
Connected.
SQL> select username,default_tablespace from dba_users;

USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
ORACLE_OCM USERDATA
DBSNMP SYSAUX
DIP USERDATA
APPQOSSYS SYSAUX
SYSTEM SYSTEM
SYS SYSTEM
OUTLN SYSTEM
XYZ USERDATA
ABC ROOM

9 rows selected.

[oracle@appsdb dpump]$ expdp directory=dpump dumpfile=dump_file_2 job_name=job_full_2 full=y

Export: Release 11.2.0.1.0 - Production on Wed Aug 31 17:58:08 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."JOB_FULL_2": /******** AS SYSDBA directory=dpump dumpfile=dump_file_2 job_name=job_full_2 full=y
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 592 KB
^C
Export> stop_job=immediate
Are you sure you wish to stop this job ([yes]/no): y

[oracle@appsdb dpump]$ expdp directory=dpump dumpfile=dump_file_3 job_name=job_full_3 full=y

Export: Release 11.2.0.1.0 - Production on Wed Aug 31 17:59:27 2016

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Starting "SYS"."JOB_FULL_3": /******** AS SYSDBA directory=dpump dumpfile=dump_file_3 job_name=job_full_3 full=y

Estimate in progress using BLOCKS method...

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 592 KB

Processing object type DATABASE_EXPORT/TABLESPACE

Processing object type DATABASE_EXPORT/PROFILE

Processing object type DATABASE_EXPORT/SYS_USER/USER

Processing object type DATABASE_EXPORT/SCHEMA/USER

Processing object type DATABASE_EXPORT/ROLE

Export> stop_job=immediate

Are you sure you wish to stop this job ([yes]/no): n

Export> continue_client

Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT

Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT

Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT

Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE

Processing object type DATABASE_EXPORT/RESOURCE_COST

Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK

Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE

Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY

Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type DATABASE_EXPORT/CONTEXT

Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM

Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM

Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC

Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM

Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ

Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM

Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT

Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC

Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE

Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE

Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW

Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER

Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA

Processing object type DATABASE_EXPORT/AUDIT

. . exported "ABC"."DEPT" 6.007 KB 7 rows

. . exported "ABC"."DUMMY" 5 KB 1 rows

. . exported "ABC"."EMP" 8.562 KB 14 rows

. . exported "ABC"."SALGRADE" 5.859 KB 5 rows

. . exported "XYZ"."DEPT" 6.007 KB 7 rows

. . exported "XYZ"."DUMMY" 5 KB 1 rows

. . exported "XYZ"."EMP" 8.562 KB 14 rows

. . exported "XYZ"."SALGRADE" 5.859 KB 5 rows

. . exported "SYSTEM"."REPCAT$_AUDIT_ATTRIBUTE" 6.328 KB 2 rows

. . exported "SYSTEM"."REPCAT$_OBJECT_TYPES" 6.882 KB 28 rows

. . exported "SYSTEM"."REPCAT$_RESOLUTION_METHOD" 5.835 KB 19 rows

. . exported "SYSTEM"."REPCAT$_TEMPLATE_STATUS" 5.484 KB 3 rows

. . exported "SYSTEM"."REPCAT$_TEMPLATE_TYPES" 6.289 KB 2 rows

. . exported "OUTLN"."OL$" 0 KB 0 rows

. . exported "OUTLN"."OL$HINTS" 0 KB 0 rows

. . exported "OUTLN"."OL$NODES" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_AQCALL" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_AQERROR" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_CALLDEST" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_DEFAULTDEST" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_DESTINATION" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_ERROR" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_LOB" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_ORIGIN" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_PROPAGATOR" 0 KB 0 rows

. . exported "SYSTEM"."DEF$_PUSHED_TRANSACTIONS" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_AUDIT_COLUMN" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_COLUMN_GROUP" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_CONFLICT" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_DDL" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_EXCEPTIONS" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_EXTENSION" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_FLAVORS" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_FLAVOR_OBJECTS" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_GENERATED" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_GROUPED_COLUMN" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_INSTANTIATION_DDL" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_KEY_COLUMNS" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_OBJECT_PARMS" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_PARAMETER_COLUMN" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_PRIORITY" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_PRIORITY_GROUP" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_REFRESH_TEMPLATES" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_REPCAT" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_REPCATLOG" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_REPCOLUMN" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_REPGROUP_PRIVS" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_REPOBJECT" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_REPPROP" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_REPSCHEMA" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_RESOLUTION" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_RESOLUTION_STATISTICS" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_RESOL_STATS_CONTROL" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_RUNTIME_PARMS" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_SITES_NEW" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_SITE_OBJECTS" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_SNAPGROUP" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_TEMPLATE_PARMS" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_TEMPLATE_SITES" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_TEMPLATE_TARGETS" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS" 0 KB 0 rows

. . exported "SYSTEM"."REPCAT$_USER_PARM_VALUES" 0 KB 0 rows

. . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE" 0 KB 0 rows

Master table "SYS"."JOB_FULL_3" successfully loaded/unloaded

******************************************************************************

Dump file set for SYS.JOB_FULL_3 is:

/u01/app/oracle/dpump/dump_file_3.dmp

Job "SYS"."JOB_FULL_3" successfully completed at 18:00:33

APPS DBA MATERIAL

Wednesday 31 August 2016

DATAPUMP?

No comments:

Post a Comment

FLIP1

FLIP