Introduction to Data Pump

1, the data pump work flow is as follows:

(1) Executing commands at the command line

(2) The EXPDP/IMPD command invokes the Dbms_datapump Pl/sql package. This API provides a high speed export import function.

(3) When data is moved, the data Pump automatically chooses direct path or external table mechanism or two combinations. When the metadata (object definition) moves

, the Data pump will use the Dbms_metadata pl/sql package. The Metadata API stores Metadata (object definitions) in XML. All processes can load and unload these metadata.

Because the data Pump invokes the server-side API, when a task is dispatched or executed, the client can exit the connection, and the task job continues on the server side, and then through the client utility

Check the status of tasks and make changes from anywhere.

It says EXPDP/IMPDP is a job and we can stop and modify it. So we're here to do a simple test:

--Export statement:

EXPDP system/oracle full=y directory=dump dumpfile=orcl_%u.dmp parallel=2

Job_name: Specifies the name of the job to export, which defaults to sys_xxx. As has been said before, the invoked APIs are job. Let's name the job, and then we'll use this job name.

C:/USERS/ADMINISTRATOR.DAVIDDAI>EXPDP system/oracle full=y directory=dump dumpfile=orcl_%u.dmp job_name=davedump

Export:release 11.2.0.1.0-production on Monday December 27 15:24:38 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connect to: Oracle Database 11g Enterprise Edition release 11.2.0.1.0-production

With the partitioning, OLAP, Data Mining and real application testing options

Start "SYSTEM". Davedump ": system/******** full=y directory=dump dumpfile=orcl_%u.dmp job_name=davedump

Using the BLOCKS method to estimate ...

Working with Object Types Database_export/schema/table/table_data

Total estimate using the BLOCKS method: 132.6 MB

Working with Object Types Database_export/tablespace

Working with Object Types Database_export/profile

Working with Object Types Database_export/sys_user/user

Working with Object Types Database_export/schema/user

Working with Object Types Database_export/role

Working with Object Types Database_export/grant/system_grant/proc_system_grant

Working with Object Types Database_export/schema/grant/system_grant

Working with Object Types Database_export/schema/role_grant

Working with Object Types Database_export/schema/default_role

Working with Object Types Database_export/schema/tablespace_quota

Working with Object Types Database_export/resource_cost

Working with Object Types Database_export/trusted_db_link

Working with Object Types Database_export/schema/sequence/sequence

---Press CTRL + C to exit interactive mode

Export>

export> status

Job: Davedump

Operation: EXPORT

Mode: Full

Status: Executing

Bytes processed: 0

Current degree of parallelism: 1

Job Error Count: 0

Dump file: d:/backup/orcl_01.dmp

Bytes written: 4,096

Dump file: d:/backup/orcl_%u.dmp

Worker 1 Status:

Process Name: DW00

Status: Executing

Object Name: Storage_context

Object type: Database_export/context

Number of objects completed: 7

Total number of objects: 7

Worker degree of parallelism: 1

--Stop the job

Export> Stop_job

Are you sure you want to stop this job ([y]/n): Yes

--Connect to job again with Job_name

C:/USERS/ADMINISTRATOR.DAVIDDAI>EXPDP system/oracle Attach=davedump

--Attach is used to establish an association between a client session and an existing export role. If you use the Attach option, you cannot specify any other selection except the connection string and the Attach option on the command line

Export:release 11.2.0.1.0-production on Monday December 27 15:26:14 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connect to: Oracle Database 11g Enterprise Edition release 11.2.0.1.0-production

With the partitioning, OLAP, Data Mining and real application testing options

Job: Davedump

Owner: SYSTEM

Operation: EXPORT

Creator Permission: TRUE

Guid:454a188f62aa4d578aa0da4c35259cd8

Start time: Monday, 27 December, 2010 15:26:16

Mode: Full

Example: ORCL

Maximum degree of parallelism: 1

EXPORT Job Parameters:

Parameter Name argument value:

Client_command system/******** full=y directory=dump dumpfile=orcl_%u.dmp job_name=davedump

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

Status: Idling

Bytes processed: 0

Current degree of parallelism: 1

Job Error Count: 0

Dump file: d:/backup/orcl_01.dmp

Bytes written: 950,272

Dump file: d:/backup/orcl_%u.dmp

Worker 1 Status:

Process Name: DW00

Status: UNDEFINED

--Start Job

Export> Start_job

--View status

export> status

Job: Davedump

Operation: EXPORT

Mode: Full

Status: Executing

Bytes processed: 0

Current degree of parallelism: 1

Job Error Count: 0

Dump file: d:/backup/orcl_01.dmp

Bytes written: 954,368

Dump file: d:/backup/orcl_%u.dmp

Worker 1 Status:

Process Name: DW00

Status: Executing

-During this period of backup, you can use the status command to view:

export> status

Job: Davedump

Operation: EXPORT

Mode: Full

Status: Executing

Bytes processed: 0

Current degree of parallelism: 1

Job Error Count: 0

Dump file: d:/backup/orcl_01.dmp

Bytes written: 954,368

Dump file: d:/backup/orcl_%u.dmp

Worker 1 Status:

Process Name: DW00

Status: Executing

Object scenario: Sysman

Object Name: aq$_mgmt_notify_qtable_t

Object type: database_export/schema/table/table

Number of objects completed: 59

Worker degree of parallelism: 1

Export> Help

------------------------------------------------------------------------------

The following commands are valid in interactive mode.

Note: Abbreviations are allowed to be used.

Add_file

Adds the dump file to the dump file set.

Continue_client

Returns to the event logging mode. If it is idle, the job is restarted.

Exit_client

Exits the client session and keeps the job running.

FILESIZE

Default file Size (in bytes) for subsequent add_file commands,

Help

Rollup Interactive commands.

Kill_job

Detach and delete the job.

PARALLEL

Changes the number of active workers for the current job.

Reuse_dumpfiles

Overwrite target dump file (if file exists) [N].

Start_job

Start or resume the current job.

Valid key values are: Skip_current.

STATUS

The frequency at which the job status is monitored, where

The default value [0] indicates that the new state is displayed as soon as a new state is available.

Stop_job

Closes job execution sequentially and exits the client.

Valid key values are: IMMEDIATE.

Note that the Paralle parameter cannot be used when the EXPDP command is switched interactively. When I started the test, I specified this parameter, and when I stop_job, I started the error. Said he couldn't find it.

The specified job_name.

2, Nls_lang Parameters on the EXPDP/IMPDP impact:

10G exp When exporting data, the data set depends on the setting of the Nls_lang parameter, and if the client side sets the Nls_lang parameter, the data is exported according to the character set of Nls_lang, if

No, it is exported according to the character set of the database itself; imp also references the Nls_lang setting when importing is a conversion to a character set.

Qs-xe-dzora-pd:/home/oracle> Echo$nls_lang

American_america.zhs16gbk

10G the new EXPDP/IMPDP becomes a server-side tool, which means that the Import Export task runs on the database server rather than on the client issuing the EXPDP/IMPDP command (although Oracle is still

Or keep the Exp/imp tool).

Oracle will not rely on and refer to the Nls_lang settings at the time of EXPDP, but simply export the data according to the character set of the database itself, IMPDP Oracle automatically determines if the characters in the DMP file

Set does not match the character set of the target database, the character set of the imported data is automatically converted. This eliminates the problem of garbled characters in the import process previously due to character set problems.

51cto Blog Oracle Little Bastard