Database Reference
In-Depth Information
For Schema Import/Export:
C:\>expdp scott/tiger@asim SCHEMAS=SCOTT
DIRECTORY=TEST_DATA_PUMP DUMPFILE=SCOTT_SCHEMA.dmp
LOGFILE=expdpscott.log
C:\>impdp scott/tiger@asim schemas=SCOTT
DIRECTORY=TEST_DATA_PUMP DUMPFILE=SCOTT_SCHEMA.dmp
LOGFILE=impdpscott.log
To improve performance we can use the PARALLEL parameter
along with "%U" in the DUMPFILE parameter to have multiple
dump files generated (or read in case of impdp) as shown in the
following command.
C:\>expdp scott/tiger@asim SCHEMAS=SCOTT
DIRECTORY=TEST_DATA_PUMP PARALLEL=4
DUMPFILE=SCOTT_SCHEMA_%U.dmp LOGFILE=expdpscott.log
OR
C:\>expdp scott/tiger TABLESPACES=USERS
DIRECTORY=TEST_DATA_PUMP DUMPFILE=TSusers.dmp
LOGFILE=TSusers.log
For Table(s) Import/Export:
C:\>expdp scott/tiger@asim tables=EMP,DEPT
directory=TEST_DATA_PUMP dumpfile=EMP_DEPT_DATA.dmp
logfile=expdpEMP_DEPT.log
C:\>impdp scott/tiger@db10g tables=EMP,DEPT
directory=TEST_DATA_PUMP dumpfile=EMP_DEPT_DATA.dmp
logfile=impdpEMP_DEPT.log
We can also use TABLE_EXISTS_ACTION=APPEND
parameter in order to import the data into existing tables.
Moreover, using INCLUDE/EXCLUDE you can quickly fine
tune the selection of tables within the schema as shown in the
following command.
Search WWH ::
Custom Search