Silent installation of database in 12C

----open folder where you unzip the database software


[oracle@cdb1 ~]$ cd /u01/app/database/
[oracle@cdb1 database]$ ls -ltr
total 36
-rwxr-xr-x.  1 oracle oinstall  500 Feb  7  2013 welcome.html
-rwxr-xr-x.  1 oracle oinstall 8533 Jul  7  2014 runInstaller
drwxr-xr-x.  2 oracle oinstall 4096 Jul  7  2014 rpm
drwxrwxr-x.  2 oracle oinstall 4096 Jul  7  2014 sshsetup
drwxr-xr-x. 14 oracle oinstall 4096 Jul  7  2014 stage
drwxr-xr-x.  4 oracle oinstall 4096 Jul 24 04:20 install
drwxrwxr-x.  2 oracle oinstall 4096 Jul 25 05:48 response

[oracle@cdb1 database]$cd response

[oracle@cdb1 response]$ ls -ltr
total 216
-rwxrwxr-x. 1 oracle oinstall  6038 Jan 24  2014 netca.rsp
-rw-r--r--. 1 oracle oinstall 25036 Jul 24 04:30 RM.rsp
-rw-rw-r--. 1 oracle oinstall 25233 Jul 24 06:09 db_install.rsp
-rwxr-xr-x. 1 oracle oinstall 74822 Jul 25 05:03 rmdbcarsp
-rwxrwxr-x. 1 oracle oinstall 74797 Jul 25 05:48 dbca.rsp

-----for safety make one duplicate copy of original file.

[oracle@cdb1 response]$ cp dbca.rsp rmdbca.rsp
[oracle@cdb1 response]$ ls -ltr
total 292
-rwxrwxr-x. 1 oracle oinstall  6038 Jan 24  2014 netca.rsp
-rw-r--r--. 1 oracle oinstall 25036 Jul 24 04:30 RM.rsp
-rw-rw-r--. 1 oracle oinstall 25233 Jul 24 06:09 db_install.rsp
-rwxr-xr-x. 1 oracle oinstall 74822 Jul 25 05:03 rmdbcarsp
-rwxrwxr-x. 1 oracle oinstall 74797 Jul 25 05:48 dbca.rsp
-rwxr-xr-x. 1 oracle oinstall 74797 Jul 25 06:14 rmdbca.rsp

[oracle@cdb1 response]$

-------edite dbca.rsp file

[oracle@cdb1 response]$ vi dbca.rsp

---------change below parameter in dbca file

RESPONSEFILE_VERSION = "12.1.0"
OPERATION_TYPE = "createDatabase"
GDBNAME = orcl
SID = orcl
CREATEASCONTAINERDATABASE =true
PDBNAME =pdb1
PDBADMINPASSWORD = "Admin"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "Admin"
SYSTEMPASSWORD = "Admin"
SOURCEDB = "orcl.example.com:1521:orcl"
SYSDBAUSERNAME = "sys"
TEMPLATENAME = "My Copy TEMPLATE"

Note:- comment all other unnecessary parameter


[oracle@cdb1 response]$ dbca -silent -responseFile dbca.rsp
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
46% complete
47% complete
52% complete
57% complete
58% complete
59% complete
62% complete
Completing Database Creation
66% complete
70% complete
74% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.

[oracle@cdb1 response]$

[oracle@cdb1 response]$ cat /etc/oratab | grep orcl

orcl:/u01/app/oracle/product/12.1.0.2/db_1:N

[oracle@cdb1 response]$ sqlplus

SQL*Plus: Release 12.1.0.2.0 Production on Sat Jul 25 06:03:01 2015

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

Enter user-name: /as sysdba

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
orcl

SQL> SELECT name, open_mode
FROM   v$pdbs
ORDER BY name;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY

SQL> CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb_adm IDENTIFIED BY Admin
  FILE_NAME_CONVERT=('/u01/app/oracle/oradata/orcl/pdbseed','/u01/app/oracle/oradata/orcl/pdb1/');  2

Pluggable database created.

SQL> COLUMN pdb_name FORMAT A20
SQL> SELECT pdb_name, status
FROM   dba_pdbs
ORDER BY pdb_name;

PDB_NAME             STATUS
-------------------- ---------
PDB$SEED             NORMAL
PDB1                       NEW

SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN READ WRITE;

Pluggable database altered.

SQL> SELECT name, open_mode
FROM   v$pdbs
ORDER BY name;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDB1                           READ WRITE

SQL>

                          ----------------END-------------------------

Create 12c database manually using database creation script.

--->OS version:

[root@O12c pfile]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.4 (Tikanga)
[root@O12c pfile]#

--->Database version:

[oracle@O12c ~]$ sqlplus
SQL*Plus: Release 12.1.0.1.0 Production on Sat Jul 18 07:35:10 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

--->Create following directory on server and give permission to oracle user and oinstall group.

[root@O12c cdb1]#mkdir -p /u01/app/oracle/admin/orcl/dpdump
[root@O12c cdb1]#mkdir -p /u01/app/oracle/admin/orcl/adump
[root@O12c cdb1]#mkdir -p /u01/app/oracle/admin/orcl/pfile
[root@O12c cdb1]#mkdir -p /u01/app/oracle/oradata/orcl/controlfile
[root@O12c cdb1]#mkdir -p/u01/app/oracle/fast_recovery_area/orcl/controlfile/
[root@O12c cdb1]#chomd 775 /u01/app/oracle/
[root@O12c cdb1]#chown oracle:oinstall /u01/app/oracle/

--->Create pfile(init_orcl.ora) in pfile directory

[root@O12c cdb1]$ cd /u01/app/oracle/admin/orcl/pfile
[root@O12c pfile]$ vi init_orcl.ora
##############################################################################
# Copyright (c) 1991, 2013 by Oracle Corporation
##############################################################################
###########################################
# Cache and I/O
###########################################
db_block_size=8192
###########################################
# Cursors and Library Cache
###########################################
open_cursors=300
###########################################
# Database Identification
###########################################
db_domain=""
db_name="orcl"
###########################################
# File Configuration
###########################################
db_create_file_dest="/u01/app/oracle/oradata"
db_recovery_file_dest="/u01/app/oracle/fast_recovery_area"
db_recovery_file_dest_size=4800m
###########################################
# Miscellaneous
###########################################
compatible=12.1.0.0.0
diagnostic_dest=/u01/app/oracle
###########################################
# Processes and Sessions
###########################################
processes=300
###########################################
# SGA Memory
###########################################
sga_target=1269m
###########################################
# Security and Auditing
###########################################
audit_file_dest="/u01/app/oracle/admin/orcl/adump"
audit_trail=db
remote_login_passwordfile=EXCLUSIVE
###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=cdb1XDB)"
###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=423m
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_tablespace=UNDOTBS1
control_files=("/u01/app/oracle/oradata/orcl/controlfile/o1_mf_bsmgyw36_.ctl",
"/u01/app/oracle/fast_recovery_area/orcl/controlfile/o1_mf_bsmgyw7v_.ctl")

--->Set ORACLE_SID variable

[oracle@O12c dbs]$ export ORACLE_SID=orcl
[oracle@O12c dbs]$ echo $ORACLE_SID
orcl
[oracle@O12c dbs]$

--->Create password file

[oracle@O12c dbs]$orapwd file=/u01/app/oracle/product/12.1.0.2/db_1/dbs/orapworcl password=Admin entries=10
[oracle@O12c dbs]$ cd /u01/app/oracle/product/12.1.0.2/db_1/dbs
[oracle@O12c dbs]$ ls -ltr
total 32
-rw-r--r-- 1 oracle oinstall 2992 Feb 3 2012 init.ora
-rw-rw---- 1 oracle oinstall 1544 Jul 6 04:48 hc_cdb1.dat
-rw-r----- 1 oracle oinstall 24 Jul 6 04:48 lkCDB1
-rw-r----- 1 oracle oinstall 7680 Jul 6 04:51 orapwcdb1
-rw-r----- 1 oracle oinstall 3584 Jul 18 07:30 spfilecdb1.ora
-rw-r----- 1 oracle oinstall 7680 Jul 18 08:41 orapworcl

-->Login to database

[oracle@O12c dbs]$ sqlplus
SQL*Plus: Release 12.1.0.1.0 Production on Sat Jul 18 08:46:42 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to an idle instance.
SQL> create spfile from pfile='/u01/app/oracle/admin/orcl/pfile/init_orcl.ora';
File created.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1336176640 bytes
Fixed Size 2288104 bytes
Variable Size 469763608 bytes
Database Buffers 855638016 bytes
Redo Buffers 8486912 bytes

SQL>@DBcreation.sql;
Database created.

-------->/*Create database script (DBcreation.sql)..
[root@O12c ~]# cd /u01/app/oracle/product/12.1.0.2/db_1/dbs
[root@O12c dbs]# vi DBcreation.sql
CREATE DATABASE orcl
USER SYS IDENTIFIED BY sys_password
USER SYSTEM IDENTIFIED BY system_password
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/orcl/redo01a.log','/u01/app/oracle/oradata/orcl/redo01b.log') SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/u01/app/oracle/oradata/orcl/redo02a.log','/u01/app/oracle/oradata/orcl/redo02b.log') SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/u01/app/oracle/oradata/orcl/redo03a.log','/u01/app/oracle/oradata/orcl/redo03b.log') SIZE 100M BLOCKSIZE 512
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/app/oracle/oradata/orcl/system01.dbf'
SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SYSAUX DATAFILE '/u01/app/oracle/oradata/orcl/sysaux01.dbf'
SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TABLESPACE users
DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/orcl/temp01.dbf'
SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE UNDOTBS1
DATAFILE '/u01/app/oracle/oradata/orcl/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
USER_DATA TABLESPACE usertbs
DATAFILE '/u01/app/oracle/oradata/orcl/usertbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED; */<-----------------------

---> Run below script for build database scripts

SQL>@/u01/app/oracle/product/12.1.0.2/db_1/rdbms/admin/catalog.sql;
(Creates the views of the data dictionary tables, the dynamic performance views,
And public synonyms for many of the views. Grants PUBLIC access to the synonyms)

SQL>@/u01/app/oracle/product/12.1.0.2/db_1/rdbms/admin/catproc.sql;
(Runs all scripts required for or used with PL/SQL.)

SQL> alter user system
2 identified by manager;
User altered.
SQL> alter user system account unlock;
User altered.
SQL>conn system/manager
Connected.
SQL>
SQL>@/u01/app/oracle/product/12.1.0.2/db_1/sqlplus/admin/pupbld.sql;
(Required for SQL*Plus. Enables SQL*Plus to disable commands by user.)

---> Bounce the database

SQL> startup force;
ORACLE instance started.
Total System Global Area 1336176640 bytes
Fixed Size 2288104 bytes
Variable Size 469763608 bytes
Database Buffers 855638016 bytes
Redo Buffers 8486912 bytes
Database mounted.
Database opened.
SQL> select name from v$database;
NAME
---------
ORCL
1 row selected.
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl/system01.dbf
/u01/app/oracle/oradata/orcl/sysaux01.dbf
/u01/app/oracle/oradata/orcl/undotbs01.dbf
/u01/app/oracle/oradata/orcl/users01.dbf
/u01/app/oracle/oradata/orcl/usertbs01.dbf
5 rows selected.

-->Create extra tablespace..

SQL>CREATE TABLESPACE apps_tbs LOGGING
DATAFILE '/u01/app/oracle/oradata/orcl/apps01.dbf'
SIZE 500M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
Tablespace created.

-- Create a tablespace for indexes, separate from user tablespace (optional)
SQL> CREATE TABLESPACE indx_tbs LOGGING
DATAFILE '/u01/app/oracle/oradata/orcl/indx01.dbf'
SIZE 100M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
Tablespace created.
SQL> select NAME from v$tablespace;
NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMPTS1
USERS
USERTBS
APPS_TBS
INDX_TBS
8 rows selected.
SQL>
Note:- database is a simple database not container database

12c Database Datapump Enhancements

12c Database Datapump Enhancements

Below are some of enhancements for Datapump

 1)      In 12c You can use the DISABLE_ARCHIVE_LOGGING Parameter

               to specify that objects be loaded with nologging of redo.

            Example:

    Schema level

$ impdp scott/tiger directory=RM_dir dumpfile=scott01.dmp transform=disable_archive_logging:Y

Import: Release 12.1.0.1.0 - Production on Mon Jul 6 05:20:49 2015

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit                                                                Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt                                                               ions

Master table "SCOTT"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting "SCOTT"."SYS_IMPORT_FULL_01":  scott/******** directory=RM_dir dumpfile                                                               =scott01.dmp transform=disable_archive_logging:Y

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

. . imported "SCOTT"."DEPT"                              6.007 KB       4 rows

. . imported "SCOTT"."EMP"                               8.757 KB      14 rows

. . imported "SCOTT"."SALGRADE"                          5.937 KB       5 rows

. . imported "SCOTT"."BONUS"                                 0 KB       0 rows

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

Job "SCOTT"."SYS_IMPORT_FULL_01" successfully completed at Mon Jul 6 05:21:00 20                                                               15 elapsed 0 00:00:10

 Nologging for Index

$impdp system/admin DIRECTORY=RM_dir DUMPFILE=scott02.dmp  schemas=scott TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y:INDEX

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded

Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01":  system/******** DIRECTORY=RM_dir DUMPFILE=scott02.dmp schemas=scott TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y:INDEX

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

. . imported "SCOTT"."DEPT"                              6.007 KB       4 rows

. . imported "SCOTT"."EMP"                               8.757 KB      14 rows

. . imported "SCOTT"."SALGRADE"                          5.937 KB       5 rows

. . imported "SCOTT"."BONUS"                                 0 KB       0 rows

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully completed at Mon Jul 6 05:26:12 2015 elapsed 0 00:00:12

               

 Logging Table No, but for other objects logging=Y      

   

$impdp system/admin DIRECTORY=RM_dir DUMPFILE=scott02.dmp  schemas=scott TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y TRANSFORM=DISABLE_ARCHIVE_LOGGING:N:TABLE

Import: Release 12.1.0.1.0 - Production on Mon Jul 6 05:42:28 2015

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded

Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01":  system/******** DIRECTORY=RM_dir DUMPFILE=scott02.dmp schemas=scott TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y TRANSFORM=DISABLE_ARCHIVE_LOGGING:N:TABLE

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

. . imported "SCOTT"."DEPT"                              6.007 KB       4 rows

. . imported "SCOTT"."EMP"                               8.757 KB      14 rows

. . imported "SCOTT"."SALGRADE"                          5.937 KB       5 rows

. . imported "SCOTT"."BONUS"                                 0 KB       0 rows

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully completed at Mon Jul 6 05:42:40 2015 elapsed 0 00:00:11

 2)      You can have timestamp printed for every object that is imported. Also during export you can use same.

Example:

     During export:

$expdp system/admin DIRECTORY=RM_dir DUMPFILE=scott04.dmp schemas=scott logtime=all

Export: Release 12.1.0.1.0 - Production on Mon Jul 6 05:46:14 2015

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

06-JUL-15 05:46:15.975: Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01":  system/******** DIRECTORY=RM_dir DUMPFILE=scott04.dmp schemas=scott logtime=all

06-JUL-15 05:46:16.293: Estimate in progress using BLOCKS method...

06-JUL-15 05:46:17.441: Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

06-JUL-15 05:46:17.487: Total estimation using BLOCKS method: 192 KB

06-JUL-15 05:46:17.734: Processing object type SCHEMA_EXPORT/USER

06-JUL-15 05:46:17.785: Processing object type SCHEMA_EXPORT/ROLE_GRANT

06-JUL-15 05:46:17.803: Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

06-JUL-15 05:46:17.825: Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA

06-JUL-15 05:46:18.144: Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

06-JUL-15 05:46:27.070: Processing object type SCHEMA_EXPORT/TABLE/TABLE

06-JUL-15 05:46:27.921: Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

06-JUL-15 05:46:28.863: Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

06-JUL-15 05:46:28.900: Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

06-JUL-15 05:46:29.199: Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

06-JUL-15 05:46:29.666: Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

06-JUL-15 05:46:29.681: Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

06-JUL-15 05:46:36.757: . . exported "SCOTT"."DEPT"                              6.007 KB       4 rows

06-JUL-15 05:46:36.781: . . exported "SCOTT"."EMP"                               8.757 KB      14 rows

06-JUL-15 05:46:36.803: . . exported "SCOTT"."SALGRADE"                          5.937 KB       5 rows

06-JUL-15 05:46:36.808: . . exported "SCOTT"."BONUS"                                 0 KB       0 rows

06-JUL-15 05:46:37.316: Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

06-JUL-15 05:46:37.321: ******************************************************************************

06-JUL-15 05:46:37.322: Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:

06-JUL-15 05:46:37.324:   /u02/datapump/scott04.dmp

06-JUL-15 05:46:37.328: Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Mon Jul 6 05:46:37 2015 elapsed 0 00:00:22

  During import:

$impdp system/admin DIRECTORY=RM_dir DUMPFILE=scott04.dmp schemas=scott logtime=all

Import: Release 12.1.0.1.0 - Production on Mon Jul 6 05:48:39 2015

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

06-JUL-15 05:48:41.814: Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded

06-JUL-15 05:48:42.022: Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01":  system/******** DIRECTORY=RM_dir DUMPFILE=scott04.dmp schemas=scott logtime=all

06-JUL-15 05:48:45.462: Processing object type SCHEMA_EXPORT/USER

06-JUL-15 05:48:45.464: Processing object type SCHEMA_EXPORT/ROLE_GRANT

06-JUL-15 05:48:45.465: Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

06-JUL-15 05:48:45.465: Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA

06-JUL-15 05:48:45.466: Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

06-JUL-15 05:48:45.467: Processing object type SCHEMA_EXPORT/TABLE/TABLE

06-JUL-15 05:48:45.549: Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

06-JUL-15 05:48:45.645: . . imported "SCOTT"."DEPT"                              6.007 KB       4 rows

06-JUL-15 05:48:45.648: . . imported "SCOTT"."EMP"                               8.757 KB      14 rows

06-JUL-15 05:48:45.651: . . imported "SCOTT"."SALGRADE"                          5.937 KB       5 rows

06-JUL-15 05:48:45.654: . . imported "SCOTT"."BONUS"                                 0 KB       0 rows

06-JUL-15 05:48:45.783: Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

06-JUL-15 05:48:45.786: Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

06-JUL-15 05:48:45.789: Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

06-JUL-15 05:48:48.306: Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

06-JUL-15 05:48:48.309: Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

06-JUL-15 05:48:48.312: Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

06-JUL-15 05:48:53.077: Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully completed at Mon Jul 6 05:48:53 2015 elapsed 0 00:00:12

 3)      You can change a table’s compression characteristics when importing the table.

$ vi import.par    ----add below parameters into file.

userid=system/admin

dumpfile=scott04.dmp

directory=RM_dir

transform=table_compression_clause:compress

:wq!

$ impdp parfile=import.par

Import: Release 12.1.0.1.0 - Production on Mon Jul 6 05:52:32 2015

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/******** parfile=import.par

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

. . imported "SCOTT"."DEPT"                              6.007 KB       4 rows

. . imported "SCOTT"."EMP"                               8.757 KB      14 rows

. . imported "SCOTT"."SALGRADE"                          5.937 KB       5 rows

. . imported "SCOTT"."BONUS"                                 0 KB       0 rows

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

Job "SYSTEM"."SYS_IMPORT_FULL_01" successfully completed at Mon Jul 6 05:52:42 2015 elapsed 0 00:00:10

4)      You can specify the compress Algorithm during export.

                  -BASIC

                  -LOW

                  -MEDIUM

Example:

$expdp scott/tiger dumpfile=scott06.dmp directory=RM_dir compression=all compression_algorithm=MEDIUM

Export: Release 12.1.0.1.0 - Production on Mon Jul 6 05:54:36 2015

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Starting "SCOTT"."SYS_EXPORT_SCHEMA_01":  scott/******** dumpfile=scott06.dmp directory=RM_dir compression=all compression_algorithm=MEDIUM

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 192 KB

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

. . exported "SCOTT"."DEPT"                              4.687 KB       4 rows

. . exported "SCOTT"."EMP"                               5.109 KB      14 rows

. . exported "SCOTT"."SALGRADE"                          4.601 KB       5 rows

. . exported "SCOTT"."BONUS"                                 0 KB       0 rows

Master table "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

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

Dump file set for SCOTT.SYS_EXPORT_SCHEMA_01 is:

  /u02/datapump/scott06.dmp

Job "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully completed at Mon Jul 6 05:55:06 2015 elapsed 0 00:00:29

$expdp scott/tiger dumpfile=scott07.dmp directory=RM_dir compression=all compression_algorithm=LOW  

Export: Release 12.1.0.1.0 - Production on Mon Jul 6 05:56:28 2015

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Starting "SCOTT"."SYS_EXPORT_SCHEMA_01":  scott/******** dumpfile=scott07.dmp directory=RM_dir compression=all compression_algorithm=LOW

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 192 KB

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

. . exported "SCOTT"."DEPT"                              4.695 KB       4 rows

. . exported "SCOTT"."EMP"                               5.273 KB      14 rows

. . exported "SCOTT"."SALGRADE"                          4.609 KB       5 rows

. . exported "SCOTT"."BONUS"                                 0 KB       0 rows

Master table "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

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

Dump file set for SCOTT.SYS_EXPORT_SCHEMA_01 is:

  /u02/datapump/scott07.dmp

Job "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully completed at Mon Jul 6 05:56:58 2015 elapsed 0 00:00:28

$expdp scott/tiger dumpfile=scott08.dmp directory=RM_dir compression=all compression_algorithm=BASIC

Export: Release 12.1.0.1.0 - Production on Mon Jul 6 05:57:07 2015

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Starting "SCOTT"."SYS_EXPORT_SCHEMA_01":  scott/******** dumpfile=scott08.dmp directory=RM_dir compression=all compression_algorithm=BASIC

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 192 KB

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

. . exported "SCOTT"."DEPT"                                  5 KB       4 rows

. . exported "SCOTT"."EMP"                               5.648 KB      14 rows

. . exported "SCOTT"."SALGRADE"                          4.906 KB       5 rows

. . exported "SCOTT"."BONUS"                                 0 KB       0 rows

Master table "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

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

Dump file set for SCOTT.SYS_EXPORT_SCHEMA_01 is:

  /u02/datapump/scott08.dmp

Job "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully completed at Mon Jul 6 05:57:37 2015 elapsed 0 00:00:29

$ expdp scott/tiger dumpfile=scott09.dmp directory=RM_dir compression=all compression_algorithm=HIGH

Export: Release 12.1.0.1.0 - Production on Mon Jul 6 06:06:53 2015

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Starting "SCOTT"."SYS_EXPORT_SCHEMA_01":  scott/******** dumpfile=scott09.dmp directory=RM_dir compression=all compression_algorithm=HIGH

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 192 KB

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

. . exported "SCOTT"."DEPT"                              4.664 KB       4 rows

. . exported "SCOTT"."EMP"                               5.023 KB      14 rows

. . exported "SCOTT"."SALGRADE"                          4.585 KB       5 rows

. . exported "SCOTT"."BONUS"                                 0 KB       0 rows

Master table "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

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

Dump file set for SCOTT.SYS_EXPORT_SCHEMA_01 is:

  /u02/datapump/scott09.dmp

Job "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully completed at Mon Jul 6 06:07:23 2015 elapsed 0 00:00:29

Size of export files.

[oracle@O12c datapump]$ ls -ltr

-rw-r----- 1 oracle oinstall 110592 Jul  6 05:55 scott06.dmp        ----  MEDIUM

-rw-r----- 1 oracle oinstall 126976 Jul  6 05:56 scott07.dmp        ----- LOW

-rw-r----- 1 oracle oinstall 110592 Jul  6 05:57 scott08.dmp        ----- BASIC

-rw-r----- 1 oracle oinstall 102400 Jul  6 06:07 scott09.dmp        -----  HIGH

5)      You can now specify the LOB Storage during import 

           Example:

$impdp scott/tiger DIRECTORY=RM_dir DUMPFILE=scott09.dmp LOB_STORAGE:SECUREFILE  

6 )      You can allows data pump jobs to be audited by creating an audit policy.

Example:

[oracle@O12c datapump]$ sqlplus

SQL*Plus: Release 12.1.0.1.0 Production on Mon Jul 6 06:15:29 2015

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

Enter user-name: /as sysdba

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt                                                               ions

SQL> CREATE AUDIT POLICY audit_dp_all_policy ACTIONS COMPONENT=DATAPUMP ALL;

Audit policy created.

SQL> AUDIT POLICY audit_dp_all_policy BY system;

Audit succeeded.

[oracle@O12c datapump]$ expdp system/admin tables=scott.emp directory=RM_dir dumpfile=scott10.dmp logfile=scott10.log

Export: Release 12.1.0.1.0 - Production on Mon Jul 6 06:16:45 2015

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Starting "SYSTEM"."SYS_EXPORT_TABLE_01":  system/******** tables=scott.emp directory=RM_dir dumpfile=scott10.dmp logfile=scott10.log

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 64 KB

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER

. . exported "SCOTT"."EMP"                               8.757 KB      14 rows

Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

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

Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:

  /u02/datapump/scott10.dmp

Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at Mon Jul 6 06:16:59 2015 elapsed 0 00:00:13

sql>EXEC DBMS_AUDIT_MGMT.FLUSH_UNIFIED_AUDIT_TRAIL;

sql>SET LINESIZE 200

sql>COLUMN event_timestamp FORMAT A30

sql>COLUMN dp_text_parameters1 FORMAT A30

sql>COLUMN dp_boolean_parameters1 FORMAT A30

sql>SELECT event_timestamp,

       dp_text_parameters1,

       dp_boolean_parameters1

FROM   unified_audit_trail

WHERE  audit_type = 'Datapump';

EVENT_TIMESTAMP                DP_TEXT_PARAMETERS1            DP_BOOLEAN_PARAMETERS1

------------------------------ ------------------------------ ------------------------------

06-JUL-15 06.16.47.359565 AM   MASTER TABLE:  "SYSTEM"."SYS_E MASTER_ONLY: FALSE, DATA_ONLY:

                               XPORT_TABLE_01" , JOB_TYPE: EX  FALSE, METADATA_ONLY: FALSE,

                               PORT, METADATA_JOB_MODE: TABLE DUMPFILE_PRESENT: TRUE, JOB_RE

                               _EXPORT, JOB VERSION: 12.1.0.0 STARTED: FALSE

                               .0, ACCESS METHOD: AUTOMATIC,

                               DATA OPTIONS: 0, DUMPER DIRECT

                               ORY: NULL  REMOTE LINK: NULL,

                               TABLE EXISTS: NULL, PARTITION

                               OPTIONS: NONE

 7)      In Oracle 12c, The ENCRYPTION_PWD_PROMPT parameter enables encryption without requiring the password to be entered as a command line parameter. Instead, the user is prompted for the password at run time, with their response not echoed to the screen.

ENCRYPTION_PWD_PROMPT=[YES | NO]

            Example:

$expdp system/admin tables=scott.emp directory=RM_dir dumpfile=scott12.dmp logfile=expdp_emp.log encryption_pwd_prompt=yes

Export: Release 12.1.0.1.0 - Production on Mon Jul 6 06:25:52 2015

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

Password:

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Encryption Password:

Starting "SYSTEM"."SYS_EXPORT_TABLE_01":  system/******** tables=scott.emp directory=RM_dir dumpfile=scott12.dmp logfile=expdp_emp.log encryption_pwd_prompt=yes

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 64 KB

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER

. . exported "SCOTT"."EMP"                               8.765 KB      14 rows

Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

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

Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:

  /u02/datapump/scott12.dmp

Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at Mon Jul 6 06:26:19 2015 elapsed 0 00:00:23

$ impdp system/admin tables=scott.emp directory=RM_dir dumpfile=scott12.dmp logfile=expdp_emp.log encryption_pwd_prompt=yes

Import: Release 12.1.0.1.0 - Production on Mon Jul 6 06:33:26 2015

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Encryption Password:

Master table "SYSTEM"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded

Starting "SYSTEM"."SYS_IMPORT_TABLE_01":  system/******** tables=scott.emp directory=RM_dir dumpfile=scott12.dmp logfile=expdp_emp.log encryption_pwd_prompt=yes

Processing object type TABLE_EXPORT/TABLE/TABLE

ORA-39151: Table "SCOTT"."EMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER

Job "SYSTEM"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at Mon Jul 6 06:33:32 2015 elapsed 0 00:00:05