oracle exp 记录

#查询当前oracle的编码
SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER='NLS_CHARACTERSET';

#设置导出的编码
set nls_lang=AMERICAN_CHINA.AL32UTF8



exp flow/xxx@orcl file=D:\test\my_test.dmp owner=flow
==================================================================================


1.第一步：导出数据库
exp flow/xxx@xe file=D:\flow_20170321bak.dmp owner=flow


2.第二步：删除原用户
drop user flow cascade


3.第三步：创建用户
CREATE USER flow IDENTIFIED BY xxx
DEFAULT TABLESPACE FLOW_DAT
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON FLOW_DAT
QUOTA UNLIMITED ON FLOW_IDX;
GRANT CONNECT,RESOURCE,DBA TO flow;


4.第四部：导入数据
imp flow/xxx@xe file=D:\flow.dmp FROMUSER=flow  TOUSER=flow ignore=y