1. exp wets/wets@192.168.0.16/orcl file=d:\daochu.dmp
也可以登录远程系统导出exp wets/wets@orcl file=d:\daochu.dmp,可能存在数据库版本不一致问题在本地无法导出
2.建立表空间,新建用户wets,付权connect,dba,resources
plsql建立表空间:
create tablespace WBJSYSTEMDB
datafile 'E:\app\HOWSO-YF007\oradata\WBJSYSTEMDB.def' size 500M
autoextend on next 100M maxsize unlimited logging
extent management local autoallocate
segment space management auto;
datafile 'E:\app\HOWSO-YF007\oradata\WBJSYSTEMDB.def' size 500M
autoextend on next 100M maxsize unlimited logging
extent management local autoallocate
segment space management auto;
3.导入数据库
imp wets/wets@orcl file=d:\daochu.dmp full=y