OCP培训笔记精华_datapump.docx

Mar18:DataPumpKEY WORDS:DATA PUMP ; EXPORT expdp ,4 modules by user/tablespace/tables/full;IMPORT impdp , 4 modules either;DIRECTORY create direacory ,grant ** on directorySQL show userUSER is SYSSQL create directory dir_18 as /ocm/logicalbak/;dump1, create a directoryDirectory created.SQL grant read,write on directory dir_18 to public;dump2,grant the right to this directoryGrant succeeded.SQL exitDisconnected from Oracle Database 11g Enterprise Edition Release .0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[oracle@db ~]$ expdp help=yexpdp help from system,exit the SQLsExport: Release .0 - Production on Sun Mar 18 10:00:05 2012Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.The Data Pump export utility provides a mechanism for transferring data objectsbetween Oracle databases. The utility is invoked with the following command: Example: expdpscott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmpYou can control how Export runs by entering the expdp command followedby various parameters. To specify parameters, you use keywords: Format: expdp KEYWORD=value or KEYWORD=(value1,value2,...,valueN) Example: expdpscott/tiger DUMPFILE=scott.dmp DIRECTORY=dmpdir SCHEMAS=scott or TABLES=(T1:P1,T1:P2), if T1 is partitioned tableUSERID must be the first parameter on the command line.The available keywords and their descriptions follow. Default values are listed within square brackets.ATTACHAttach to an existing job.For example, ATTACH=job_name.COMPRESSIONReduce the size of a dump file.Valid keyword values are: ALL, DATA_ONLY, [METADATA_ONLY] and NONE.CONTENTSpecifies data to unload.Valid keyword values are: [ALL], DATA_ONLY and METADATA_ONLY.DATA_OPTIONSData layer option flags.Valid keyword values are: XML_CLOBS.DIRECTORYDirectory object to be used for dump and log files.DUMPFILESpecify list of destination dump file names [expdat.dmp].For example, DUMPFILE=scott1.dmp, scott2.dmp, dmpdir:scott3.