Shulou(Shulou.com)05/31 Report--

This article mainly explains "Overview of Oracle data pump". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Now let the editor to take you to learn the "Overview of Oracle data pump"!

Overview of data pump

Data pump (DATAPUMP) is a technology that transfers data at high speed between databases and between databases and operating systems (10g launched).

Physical backup comparison

Physical backup is the dump of ORACLE physical files (such as data files, control files, archive log files, etc.)

Physical backup is designed to completely restore the entire database, requiring exactly the same backup environment and recovery environment

Logical backup is designed to back up the data itself, which is highly portable, but the backup and recovery speed is slow, and large business systems generally do not use it.

Overview of logical backup

Logical backup is the export of database objects (such as users, tables, stored procedures, etc.) using EXPORT and other tools.

Operation steps

1. Create directory objects (where to import and export)

CREATEDIRECTORY directory name (dump_dir) as' absolute path'

2.dump_dir directory grant

GRANTread,writeondirectory directory name to import and export user

SELECT*FROMDBA_DIRECTORIES; queries all created directories

DROPdirectory directory name; delete directory

3.expdq export (EXPDP and IMPDP are Oracle server tools, exit sqlplus)

First: full export of the database:

Expdp username / password @ orcldumpfile= export file name .dmpdirectory = directory name full=ylogfile= log name .log; (in the same directory as dmp)

Second: export by user:

Expdp username / password @ orclschemas= user dumpfile= export file name .dmpdirectory = directory name logfile= log name .dmpdirectory

Third: export by tablespace:

Expdp username / password @ orcltablespace= table space name dumpfile= export file name .dmpdirectory = directory name logfile= log name .dmpdirectory

Fourth: export according to the table:

Expdp username / password @ orcltables= table name dumpfile= export file name .dmp directory = directory name logfile= log name. Log

Export table structure

Expdp username / password @ orcldirectory= directory name dumpfile= export file name .dmpcontent = metadata_onlytables= (aforme b)

Metadata_only representative only exports table structure

Fifth: guide according to query conditions:

Expdp username / password @ orcltables= table name = 'where condition = value' dumpfile= export file name .dmpdirectory = directory name logfile= log name .dmpdirectory

At this point, I believe that you have a deeper understanding of the "overview of the Oracle data pump", you might as well come to the actual operation! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.