1、导出
比如:将服务器该IP的system用户的全部表全部导出,owner=(system)为所导出的用户
exp system/manager@192.168.0.168:1521/orcl file=d:\wjh.dmp owner=(system,sys)
2、创建本地的数据库
在sqlplus
conn sys/change_on_install as sysdba
create user username identified by password;
grant create session,create table,create view to username;
grant DBA to uername;
3、在cmd
imp 用户/密码 file=*.dmp commit=y full=y