1.先准备好在Oracle数据库中创建一个用户如ect_shanxi,代码如下:
create user ect_shanxi identified by ect_shanxi**;//创建用户名和密码
grant connect,resource to ect_shanxi; //以下皆为授予权限
grant create any sequence to ect_shanxi;
grant create any table to ect_shanxi;
grant delete any table to ect_shanxi;
grant insert any table to ect_shanxi;
grant select any table to ect_shanxi;
grant unlimited tablespace to ect_shanxi;
grant execute any procedure to ect_shanxi;
grant update any table to ect_shanxi;
grant create any view to ect_shanxi;
grant sysdba to ect_shanxi;
grant imp_full_database to ect_shanxi;
2.cmd打开命令行窗口,输入sqlplus,输入sys as sysdba
3.在SQL>后输入上述代码即可创建用户,
4.创建成功后,输入exit退出
5.用ect_shanxi/ect_shanxi登录plsql客户端,此时表为空
6.接下来导入表的dmp文件,将dmp存放在如下所示的位置 D:\anqing180705.dmp
7.将代码:imp ect_shanxi/ect_shanxi file=D:\anqing180705.dmp full=y输入到命令行
8.导入完成之后,刷新plsql的tables,表都导入进来了