服务器备份数据库和导入dmp文件

exp name/passwd@ip:1521/servicename file=./test.dmpowner=name tables=tablename;imp name/passwd@ip:1521/servicename file=./test.dmp ignore=ygrants=no buffer=640000 commit=y fromuser=name touser=toname;

q1373584789

1291人浏览 · 2020-12-10 09:48:17

q1373584789 · 2020-12-10 09:48:17 发布

exp name/passwd@ip:1521/servicename file=./test.dmp 
owner=name tables=tablename;

imp name/passwd@ip:1521/servicename file=./test.dmp ignore=y 
grants=no buffer=640000 commit=y fromuser=name touser=toname;

expdp name/passwd@ip/servicename directory=DUMP_DIR
dumpfile=test.dmp logfile=test.log tables=tablename;

impdp name/passwd@ip/servicename directory=DMPDIR 
dumpfile=test.dmp logfile=test.log 
REMAP_SCHEMA=fromuser:touser
SKIP_UNUSABLE_INDEXES=Y TABLE_EXISTS_ACTION=append