创建用户:
create user pitaya identified by 123456 default tablespace pty;
create user boss identified by 123456 default tablespace pty;
授权:
grant all privileges to boss;
grant all privileges to pitaya;
创建资源文件:
create directory testdirqqq as ‘/opt/oracle/admin/orcl/’;
数据泵方式授权要进行这种方式授权
grant imp_full_database to boss
grant exp_full_database to boss
然后在cmd里面进行同步即可
impdp BOSS/123456@192.168.2.126:1521/ORCL DIRECTORY=testdirqqq DUMPFILE=BOSS.DMP REMAP_SCHEMA=BOSS:BOSS
impdp PITAYA/123456@192.168.2.126:1521/ORCL DIRECTORY=testdirqqq DUMPFILE=PITAYA.DMP REMAP_SCHEMA=PITAYA:PITAYA
PITAYA:PITAYA: 从第一个输入到第二个
grant select ,insert,update ,delete on 表 to xxx 用户
授权表
注意 如果是向本地的oracle里面导入数据的话
要把数据库文件放到d盘的aaa下
linux则不用