1---以DBA权限的用户登录创建新用户
create user jxcredit identified by jxcredit temporary tablespace TEMP;
create user jxcredit identified by jxcredit temporary tablespace TEMP;
3--给新用户赋予权限
grant connect,resource,dba to jxcedit;
grant connect,resource,dba to jxcedit;
3--导入表数据及结构
imp userid=jxcredit/jxcredit@orcle file=D:\jxcredit2012.dmp log=D:\jxct2012.log touser=jxcredit full=y;
4--导出表数据
exp userid=jxcredit/jxcredit@orcl file=d:/jxcms.dmp log=d:/jxcms.log owner=jxcredit buffer=809600;
注意:导入导出操作在cmd黑窗口中执行