1 创建 dblink
grant create database link to xielj;
create database link uat2local
connect to xielj identified by 123456
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 99.12.122.88)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))';
drop database link uat2local
2 创建用户/Scheme
CREATE USER xielj IDENTIFIED BY 123456;
default tablespace user_dat;
temporary tablespace user_temp;
grant create session,resource to xielj ;
grant select on v_$session to xielj ;
3 创建表空间
create tablespace USER_DAT
logging
datafile 'D:\app1\LocalUser\oradata\orcl\user_dat.dbf'
size 500m
autoextend on
next 50m maxsize 20480m
extent management local;