资源描述：
《OCP培训笔记精华_datapump》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、Mar18:DataPumpKEYWORDS:DATAPUMP;EXPORTexpdp,4modulesbyuser/tablespace/tables/full;IMPORTimpdp,4moduleseither;DIRECTORYcreatedireacory,grant**ondirectorySQL>showuserUSERis"SYS"SQL>createdirectorydir_18as'/ocm/logicalbak/';>>>dump1,createadirectoryDirectoryc
2、reated.SQL>grantread,writeondirectorydir_18topublic;>>>dump2,granttherighttothisdirectoryGrantsucceeded.SQL>exitDisconnectedfromOracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-ProductionWiththePartitioning,OLAP,DataMiningandRealApplicationTestingoption
3、s[oracle@db~]$expdphelp=y>>>expdphelpfromsystem,exittheSQLsExport:Release11.2.0.1.0-ProductiononSunMar1810:00:052012Copyright(c)1982,2009,Oracleand/oritsaffiliates.Allrightsreserved.TheDataPumpexportutilityprovidesamechanismfortransferringdataobjectsbetwee
4、nOracledatabases.Theutilityisinvokedwiththefollowingcommand:Example:expdpscott/tigerDIRECTORY=dmpdirDUMPFILE=scott.dmpYoucancontrolhowExportrunsbyenteringthe'expdp'commandfollowedbyvariousparameters.Tospecifyparameters,youusekeywords:Format:expdpKEYWORD=va
5、lueorKEYWORD=(value1,value2,...,valueN)Example:expdpscott/tigerDUMPFILE=scott.dmpDIRECTORY=dmpdirSCHEMAS=scottorTABLES=(T1:P1,T1:P2),ifT1ispartitionedtableUSERIDmustbethefirstparameteronthecommandline.-------------------------------------------------------
6、-----------------------Theavailablekeywordsandtheirdescriptionsfollow.Defaultvaluesarelistedwithinsquarebrackets.ATTACHAttachtoanexistingjob.Forexample,ATTACH=job_name.COMPRESSIONReducethesizeofadumpfile.Validkeywordvaluesare:ALL,DATA_ONLY,[METADATA_ONLY]a
7、ndNONE.CONTENTSpecifiesdatatounload.Validkeywordvaluesare:[ALL],DATA_ONLYandMETADATA_ONLY.DATA_OPTIONSDatalayeroptionflags.Validkeywordvaluesare:XML_CLOBS.DIRECTORYDirectoryobjecttobeusedfordumpandlogfiles.DUMPFILESpecifylistofdestinationdumpfilenames[expd
8、at.dmp].Forexample,DUMPFILE=scott1.dmp,scott2.dmp,dmpdir:scott3.dmp.ENCRYPTIONEncryptpartorallofadumpfile.Validkeywordvaluesare:ALL,DATA_ONLY,ENCRYPTED_COLUMNS_ONLY,METADATA_ONLYandNONE.ENCRYPTION_ALGORITHMSp
