OCP培训笔记精华_datapump.docxVIP

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