||Oracle Tips by Burleson
Oracle10g Grid Computing
Chapter 17 -
Oracle’s Grid Integration Technologies
Data Pump Export
job_name – This is used to identify the
export job in subsequent actions such as when the ATTACH parameter
is used to attach a job (see the previous example for ATTACH). The
job name can be up to 30 characters. In the default
system-generated name, SYS_<operation>_<mode>_NN, <operation> is the
type of export operations (EXPORT, EXTIMATE, and so on) you perform,
<mode> can be FULL, SCHEMAS, TABLESPACES, transport_tablespaces or
TABLES, and NN is a two-digit monotonically increasing integer start
Here are two examples of system-generated job
keep_master – A Master Table is created
at the beginning of an export operation. At successful completion
of the export job, this table is written to the dump file set, and
then dropped. If you set keep_master=y, the Master Table will not
be dropped at the end of the job (this is useful for debugging
network_link – When this parameter is
set to Y, it enables a network export via a valid database link.
The data moves from a remote database to a dump file set.
nologfile – When this parameter is set
to Y, then no log file will be written out (the default is N).
parallel – This parameter specifies the
maximum number of threads of active execution servers operating on
behalf of the export job (the default value is 1). This execution
set is comprised of a combination of worker processes and parallel
slave processes. The Master Control process and worker processes
acting as query coordinators in parallel query operations do not
count towards this total. (Tip: The value specified for parallel
should be at least as large as the number of output files specified
with the dumpfile parameter.)
schemas – This parameter defaults to the
current user’s schema. If a user has the exp_full_database
privilege, a list of schemas can be specified for an export (see the
example for the include parameter).
status – This parameter specifies how
frequently detailed progress information should be written to the
client’s output terminal (the default value is 0). You can also use
status in interactive mode to check the status of a job, as follows:
Percent Done: 100
Job Error Count: 0
Worker 1 Status:
State: WORK WAITING
transport_full_check – When it is set to
Y, this parameter verifies that there are no dependencies between
those objects inside the transportable set and those outside the
transportable set (the default value is N).
version – This specifies the version of
Oracle database to which only compatible database objects are to be
For more information,
see the book
Grid and Real Application Clusters 30% off if you
buy it directly from Rampant TechPress .
Written by top Oracle
experts, this RAC book has a complete online code depot with
ready to use RAC scripts.
can offer world-class remote Oracle database support at super-affordable prices.
Oracle DBA service provides 100% of the remote Oracle database administration
needs for your company, and includes 24x7 access to our staff of 100% OCP
Certified Oracle DBAs.
We require a 12 month service commitment and include the following services:
- Initial configuration review and problem identification
- Installation of Oracle statistics collection mechanisms and quarterly
database growth summaries
- Hourly monitoring of your Oracle database for pending problems
- Periodic performance analysis & identification of tuning activities
- Twenty Four hour Oracle emergency support
- Reporting and resolving all serious Oracle alert log messages
- Free use of the BC
- Quick response emergency support for production database outages
- Four hours of free remote DBA support every month. You can use these free
hours for any DBA activity, including database analysis, system design,
production migrations or personal mentoring.
information, please visit www.dba-oracle.com.