查看oracle服务端的字符集:select * from v$nls_parameters where parameter='NLS_CHARACTERSET';
设置exp的字符集与oracle服务端的一致:export NLS_LANG='AMERICAN_AMERICA.UTF8'
导出:
exp scott/密码@10.10.10.85/xe file=C:\Users\CTTICSH\Desktop\oracle_back\85Scott.dmp owner=scott;
导入:
imp scott/密码@10.10.10.85/xe file=F:\oracle\zwzx20200902.dmp