1. 当前位置:网站首页 > Oracle相关

oracle dump 方法


$sqlplus/nolog                                                                                                    #进入sqlplus

SQL>conn/as sysdba                                                                                          #进入sysdba权限

CREATE DIRECTORY datadir1 AS '/home/oracle/dump_dir';                                    #数据库定义目录变量

SQL> ! mkdir -p /home/oracle/dump_dir                                                              #创建系统真实目录

GRANT READ,WRITE ON DIRECTORY datadir1 TO scott;                                        #授权给scott变量目录权限

grant EXP_FULL_DATABASE to scott;                                                                   #授权给scott所有数据库导出权限

alter user scott account unlock;                                                                           #解锁scott

disconnect                                                                                                         #退出sysdba权限

conn scott/tiger@oral;                                                                                         #用scott登陆,提示修改密码

quit                                                                                                                   #退出sqlplus

$chmod 777 /home/oracle/dump_dir                                                                     #对真实目录读写权限开放

$expdp scott/tiger DIRECTORY=datadir1 DUMPFILE=full.dmp FULL=y LOGFILE=datadir1:expschema.log     #dump命令全集,scott密码为修改后

 


本文最后更新于2015-9-18,已超过 3个月没有更新,如果文章内容或图片资源失效,请留言反馈,我们会及时处理,谢谢!
版权说明

本文地址:https://www.chensj.net/?post=48
未标注转载均为本站远程,转载请注明文章出处:

联系我们

在线咨询:点击这里给我发消息

微信号:chensj923

工作日:9:00-23:00,节假日休息

扫码关注