【Oracle笔记】数据库dump导入和导出

程序员云帆哥

发布于 2022-05-12 08:22:59

3.2K0

mkdir /data/sharedata/mydump
chown -R oracle:oinstall /data/sharedata/mydump

ORACLE_HOME=/oralce/product/11.2.0.4/dbhome
PATH=$ORACLE_HOME:$PATH

打开监听器：lsnrctl start
查看监听器运行状态：lsnrctl status

sqlplus / as sysdba
startup

create directory mydump as '/data/sharedata/mydump'；
select * from dba_directories;

impdp \'/ as sysdba\' directory=mydump dumpfile=mydb.dmp table_exists_action=replace

expdp \'/ as sysdba\' SCHEMAS=TEST directory=mydump dumpfile=mydb.dmp logfile=mydb.log

本文参与腾讯云自媒体同步曝光计划，分享自作者个人站点/博客。

原始发表：2018-04-26，如有侵权请联系 cloudcommunity@tencent.com 删除