oracle---exp/imp 

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
exp 'test/"test@#1234"@orcl' file=/home/oracle/bak/data.dmp owner=test log=/home/oracle/bak/exp.log buffer=1024000
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
imp 'test/"test@#1234"@orcl' file=/home/oracle/bak/data.dmp log=/home/oracle/log/imp.log buffer=1024000 fromuser=test touser=test ignore=y TABLESPACES=user

 

posted @ 2022-10-09 11:31  dcwange11  阅读(24)  评论(0)  编辑  收藏  举报