Several examples of impd expd in ORACLE Database: impdexpd
# Export by table
[Oracle @ host2 ~] $ Expdp u1/tiger tables = family dumpfile = 'u1 _ family. dump 'directory = dump_dir job_name = family1
Export: Release 10.2.0.5.0-64bit Production on Monday, 11 August, 2014 12:58:39
Copyright (c) 2003,200 7, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
And Real Application Testing options
Starting "U1". "FAMILY1": u1/******** tables = family dumpfile = uw.family.dump directory = dump_dir job_name = family1
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
.. Exported "U1". "FAMILY" 5.984 KB 2 rows
Master table "U1". "FAMILY1" successfully loaded/unloaded
**************************************** **************************************
Dump file set for U1.FAMILY1 is:
/Oracle/product/10.2.0.5/rdbms/log/uw.family.dump
Job "U1". "FAMILY1" successfully completed at 12:58:44
# Cross-user import:
[Oracle @ host2 ~] $ Impdp u2/tiger dumpfile = uw.family_1.dump directory = dump_dir REMAP_SCHEMA = u1: u2
Import: Release 10.2.0.5.0-64bit Production on Monday, 11 August, 2014 13:23:26
Copyright (c) 2003,200 7, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
And Real Application Testing options
Master table "U2". "SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "U2". "SYS_IMPORT_FULL_01": u2/******** dumpfile = uw.family_1.dump directory = dump_dir REMAP_SCHEMA = u1: u2
Processing object type TABLE_EXPORT/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
.. Imported "U2". "FAMILY" 5.984 KB 2 rows
Job "U2". "SYS_IMPORT_FULL_01" successfully completed at 13:23:30
# Modify the path
Create or replace directory dump_dir as '/oracle/backup ';
Grant read, write on directory dump_dir to u2;
# Export by user
[Oracle @ host2 ~] $ Expdp u1/tiger schemas = u1 dumpfile = 'u1. dump 'directory = dump_dir
Export: Release 10.2.0.5.0-64bit Production on Monday, 11 August, 2014 13:25:40
Copyright (c) 2003,200 7, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
And Real Application Testing options
Starting "U1". "SYS_EXPORT_SCHEMA_01": u1/******** schemas = u1 dumpfile = u1.dump directory = dump_dir
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
.. Exported "U1". "FAMILY" 5.984 KB 2 rows
Master table "U1". "SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
**************************************** **************************************
Dump file set for U1.SYS _ EXPORT_SCHEMA_01 is:
/Oracle/backup/u1.dump
Job "U1". "SYS_EXPORT_SCHEMA_01" successfully completed at 13:26:06
# Import user-exported data
[Oracle @ host2 ~] $ Impdp u2/tiger dumpfile = u1.dump directory = dump_dir REMAP_SCHEMA = u1: u2
Import: Release 10.2.0.5.0-64bit Production on Monday, 11 August, 2014 13:26:58
Copyright (c) 2003,200 7, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
And Real Application Testing options
Master table "U2". "SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "U2". "SYS_IMPORT_FULL_01": u2/******** dumpfile = u1.dump directory = dump_dir REMAP_SCHEMA = u1: u2
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER: "U2" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
.. Imported "U2". "FAMILY" 5.984 KB 2 rows
Job "U2". "SYS_IMPORT_FULL_01" completed with 1 error (s) at 13:27:02
# Export by tablespace
[Oracle @ host2 ~] $ Expdp u1/tiger tablespace = u1 dumpfile = 'u1 _ u1.dump 'directory = dump_dir
LRM-00101: unknown parameter name 'tablespace'
[Oracle @ host2 ~] $ Expdp u1/tiger tablespaces = u1 dumpfile = 'u1 _ u1.dump 'directory = dump_dir
Export: Release 10.2.0.5.0-64bit Production on Monday, 11 August, 2014 13:28:39
Copyright (c) 2003,200 7, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
And Real Application Testing options
Starting "U1". "SYS_EXPORT_TABLESPACE_01": u1/******** tablespaces = u1 dumpfile = u1_u1.dump directory = dump_dir
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
Processing object type TABLE_EXPORT/TABLE/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/COMMENT
.. Exported "U1". "FAMILY" 5.984 KB 2 rows
Master table "U1". "SYS_EXPORT_TABLESPACE_01" successfully loaded/unloaded
**************************************** **************************************
Dump file set for U1.SYS _ EXPORT_TABLESPACE_01 is:
/Oracle/backup/u1_u1.dump
Job "U1". "SYS_EXPORT_TABLESPACE_01" successfully completed at 13:29:34
# Using tablespace import (remap_tablespace remap_user)
[Oracle @ host2 ~] $ Impdp u2/tiger dumpfile = uw.u1.dump directory = dump_dir REMAP_TABLESPACE = u1: u3 REMAP_SCHEMA = u1: u3
[Oracle @ host2 ~] $ Impdp u2/tiger dumpfile = uw.u1.dump directory = dump_dir REMAP_TABLESPACE = u1: u3 REMAP_SCHEMA = u1: u3
Import: Release 10.2.0.5.0-64bit Production on Monday, 11 August, 2014 13:39:35
Copyright (c) 2003,200 7, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
And Real Application Testing options
Master table "U2". "SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "U2". "SYS_IMPORT_FULL_01": u2/******** dumpfile = u1_u1.dump directory = dump_dir REMAP_TABLESPACE = u1: u3 REMAP_SCHEMA = u1: u3
Processing object type TABLE_EXPORT/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
.. Imported "U3". "FAMILY" 5.984 KB 2 rows
Job "U2". "SYS_IMPORT_FULL_01" successfully completed at 13:39:37
# Create a tablespace and a user shemas
# Table appending
[Oracle @ host2 ~] $ Impdp u2/tiger dumpfile = u1_u1.dump directory = dump_dir REMAP_TABLESPACE = u1: u3 REMAP_SCHEMA = u1: u3 table_exists_action = append
# Table replacement
[Oracle @ host2 ~] $ Impdp u2/tiger dumpfile = u1_u1.dump directory = dump_dir REMAP_TABLESPACE = u1: u3 REMAP_SCHEMA = u1: u3 table_exists_action = replace;
Import: Release 10.2.0.5.0-64bit Production on Monday, 11 August, 2014 13:44:18
Copyright (c) 2003,200 7, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
And Real Application Testing options
Master table "U2". "SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "U2". "success": u2/******** dumpfile = uw.u1.dump directory = dump_dir REMAP_TABLESPACE = u1: u3 REMAP_SCHEMA = u1: u3 table_exists_action = replace
Processing object type TABLE_EXPORT/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
.. Imported "U3". "FAMILY" 5.984 KB 2 rows
Job "U2". "SYS_IMPORT_FULL_01" successfully completed at 13:44:21