Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Home
Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients

 

Free Oracle Tips


 
HTML Text AOL

Free Oracle App Server Tips


 
HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

Remote Oracle

Custom Oracle Training

 

   
  Oracle Tips by Burleson

Oracle10g Grid Computing with RAC
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 at 01.

Here are two examples of system-generated job names:

SYS_EXPORT_SCHEMA_01

 
SYS_ESTIMATE_FULL_02

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 purposes).

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:

Export> status

Job: SYS_ESTIMATE_SCHEMA_01
  Operation: ESTIMATE                      
  Mode: SCHEMA                        
  State: COMPLETING                    
  Percent Done: 100
  Degree: 1
  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 exported.


For more information, see the book Oracle 11g 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.


Remote DBA Services

Burleson Consulting can offer world-class remote Oracle database support at super-affordable prices.

Our remote 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 TablePack, ServerPack and AuditPack services
  • 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.

For more information, please visit www.dba-oracle.com.

   
 
 
 

Oracle performance tuning book

 

 

Oracle performance tuning software

 
Oracle performance tuning software
 
Oracle performance Tuning 10g reference poster
 
Oracle training in Linux commands
 
Oracle training Excel
 
 
 
 

 

email BC:


Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.