Database Reference
In-Depth Information
C:\>expdp scott/tiger@asim INCLUDE=TABLE:"IN ('EMP', 'DEPT')"
directory=TEST_DATA_PUMP dumpfile=SCOTT_SCHEMA.dmp
logfile=expdpSCOTT.log
C:\>expdp scott/tiger@asim EXCLUDE=TABLE:"= 'HR'"
directory=TEST_DATA_PUMP dumpfile=SCOTT_SCHEMA.dmp
logfile=expdpSCOTT.log
To get more information about other available paramters in
expdp and impdp use the following commands.
C:\>expdp help=y
C:\>impdp help=y
Simple Export/Import
We can perform logical backup and recovery using Oracle's
Export and Import utilities. The major benefits of this
import/export are logical backup/recovery, moving data from
one Oracle database to another Oracle database and
reorganization of database by using COMPRESS=Y.
We export table or complete schema (i.e. all the objects within
the schema like tables, views, sequences etc.) to an external
binary file called Dump file.
The dump file is having extension of .dmp and a default name of
expdata.dmp. As it's a binary file so it is not possible to
read/understand that file. We have to use the Import utility to
dump this file into any Oracle database.
There are two ways to do export of data from Oracle database
using Export utility. One is called the “Conventional Path
Export” and other is called the “Direct Path Export”.
Conventional path export is the default mode of the Export
utility where as Direct path export can be achieved by setting
DIRECT=Y.
Search WWH ::
Custom Search