What are the Data Pump Export Examples?

1

• What are the Data Pump Export Examples?

Things released by Data Pump Export Application
can be brought in into a data source using
Details Push Transfer Application. The following
explains how to use Details Pump Export
Application to import objects Importing Complete
Dispose of File If you want to Transfer all the
objects in a dump data file you can kind the
following control. impdp hr/hr
DUMPFILEdpump_dir1expfull.dmp
FULLy LOGFILEdpump_dir2full_imp.log
2
This example imports everything from the
expfull.dmp dump data file. In this example, a
DIRECTORY parameter is not offered. Therefore, a
directory item must be offered on both the
DUMPFILE parameter and the LOGFILE
parameter Importing Things of One Schema to
another Schema The following example plenty all
platforms owned by hr schema to scott schema
impdp SYSTEM/password DIRECTORYdpump_dir1
DUMPFILEhr.dmp REMAP_SCHEMAhrscott
3
If SCOTT consideration are available in the data
source then hr objects will be packed into scott
schema. If scott consideration does not are
available, then Transfer Application can provide
the SCOTT consideration with an useless security
password because, the dump data file was released
by the customer SYSTEM and brought in by the
customer SYSTEM who has DBA rights. Loading
Things of one Tablespace to another
Tablespace. You can use remap_tablespace choice
to import objects of one tablespace to another
tablespace by providing the command impdp
SYSTEM/password DIRECTORYdpump_dir1
DUMPFILEhr.dmp REMAP_TABLESPACEuserssales
4
The above example plenty platforms, saved in
customers tablespace, in the revenue
tablespace. Generating SQL File containing DDL
instructions using Details Push Import You can
produce SQL data file which contains all the DDL
instructions which Transfer would have
implemented if you actually run Transfer
utility The following is an example of using the
SQLFILE parameter. impdp hr/hr
DIRECTORYdpump_dir1 DUMPFILEexpfull.dmp SQLFILE
dpump_dir2expfull.sql
5
A SQL data file known as expfull.sql is published
to dpump_dir2. Importing objects of only a
Particular Schema If you have the
IMP_FULL_DATABASE part, you can use this
parameter to carry out a schema-mode import by
specifying only one schema other than your own or
a record of schemas to import. First, the schemas
themselves are manufactured (if they do not
already exist), such as system and part allows,
security password record, and so on. Then all
objects included within the schemas are brought
in. Nonprivileged customers can specify only
their own schemas. In that situation, no details
about the schema meaning is brought in, only the
objects included within it.
6
Example The following is an example of using the
SCHEMAS parameter. You can make the expdat.dmp
data file used in this example by operating the
example offered for the Trade SCHEMAS
parameter. impdp hr/hr SCHEMAShr,oe
DIRECTORYdpump_dir1 LOGFILEschemas.log
DUMPFILEexpdat.dmp
7
The hr and oe schemas are brought in from the
expdat.dmp data file. The log data file,
schemas.log, is published to dpump_dir1 Importing
Only Particular Tables The following example
reveals a easy use of the TABLES parameter to
import only the workers and tasks platforms from
the expfull.dmp data file. You can make the
expfull.dmp dump data file used in this example
by operating the example offered for the Complete
Database Trade in Past Subject. impdp hr/hr
DIRECTORYdpump_dir1 DUMPFILEexpfull.dmp
TABLESemployees,jobs
8
This will import only workers and tasks platforms
from the DUMPFILE. Running Details Push Transfer
Application in Entertaining Mode Similar to the
DATA PUMP EXPORT utility the Details Push
Transfer Jobs can also be revoked, began again or
murdered. And, you can affix to an already
current import job from any customer device. For
Example, assume a DBA begins a publishing by
writing the following control at one customer
device CLNT1 by writing the following
command impdp scott/tiger_at_mydb FULLy
DIRECTORYdata_pump_dir DUMPFILEfull.dmp
LOGFILEmyfullexp.log JOB_NAMEmyfullJob
9
Are you sure you wish to quit this job (y/n)
y The job is placed in a ceased condition and
leaves the customer. After completing his other
perform, the DBA wants to proceed the export job
and the customer device from where he actually
began the job is closed because, the customer has
closed his/her cottage. So now the DBA will go to
another customer device and he reattach to the
job by writing the following command impdp
hr/hr_at_mydb ATTACHmyfulljob After the job
position is shown, he can problem the
CONTINUE_CLIENT control to proceed signing method
and reboot the myfulljob job.
10
mportgt CONTINUE_CLIENT A concept is shown that
the job has been reopened, and handling position
is outcome to the customer. Note After
reattaching to the Job a DBA can also destroy the
job by writing KILL_JOB, if he doesnt want to
follow the import job. Join the best oracle
training to get oracle dba jobsto make your
career in this field.