#导出dmp
exp userid=‘system/mofang360’ file=‘D:\1.dmp’ log=‘D:\1dmp.log’ owner=system
#导入dmp(必须是dba用户)
imp userid=‘jvm/qwer1234@XE’ file=‘D:\nxwork\nx\Desktop\me\1.dmp’ log=‘D:\nxwork\nx\Desktop\me\imp.log’ full=y ignore=y buffer=1073741824 STATISTICS=NONE COMMIT=yes
1.sqlplus /nolog
2. connect /as sysdba
3. create user jvm identified by qwer1234;
#不知道啥原因,字母在前面就好了
create user jvm identified by 1234qwer *
ERROR at line 1:
ORA-00922: missing or invalid option
4.授权
grant connect,resource to jvm
5.取消授权
revoke connect,resource from jvm
…
exp system/“mofang360@SYSTEM” file=d:\daochu.dmp tables=SSSJ_BYB
exp system/mofang360 file=d:\daochu.dmp tables=SSSJ_BYB