拉新网 - 挖掘京东今日特价爆款商品 - 线报平台

小天天

Moderator

注册时间： 2019-09-29

帖子： 886

oracle expdb导出数据

su - oracle
sqlplus / as sysdba
create directory ora_dmp as '/data/目录';
grant read,write on directory ora_dmp to public;
expdp system/密码 version=11.2.0.1.0 schemas=ORA_OPENPLATFORM directory=ora_dmp dumpfile=ORA_OPENPLATFORM.dmp logfile=ORG_OPENPLATFORM20231109.log
expdp system/密码 version=11.2.0.1.0 schemas=ORA_ORGANIZATION directory=ora_dmp dumpfile=ORA_ORGANIZATION.dmp logfile=ORG_ORGANIZATION20231109.log
expdp system/密码 version=11.2.0.1.0 schemas=ORA_MANAGER directory=ora_dmp dumpfile=ORA_MANAGER.dmp logfile=ORA_MANAGER20231109.log
expdp system/密码 version=11.2.0.1.0 schemas=ORA_CONTACT directory=ora_dmp dumpfile=ORA_CONTACT.dmp logfile=ORA_CONTACT20231109.log
expdp system/密码 version=11.2.0.1.0 schemas=ORA_KMS directory=ora_dmp dumpfile=ORA_KMS.dmp logfile=ORA_KMS20231109.log
expdp system/密码 version=11.2.0.1.0 schemas=ORA_WORKBENCH directory=ora_dmp dumpfile=ORA_WORKBENCH.dmp logfile=ORA_WORKBENCH20231109.log

#若使用sys账号来导数据

expdp \'sys/"密码" AS SYSDBA\'
expdp  \'sys/"abc@GSLRAC" AS SYSDBA\' version=11.2.0.1.0 schemas=ORA_OPENPLATFORM directory=ora_dmp dumpfile=ORA_OPENPLATFORM.dmp logfile=ORG_OPENPLATFORM20231109.log