#oracle数据库安装完成后,有两个系统级的用户
system 默认密码为 :manager
sys 默认密码为 :change_on_install
#创建表空间tbs_xxxdba,初始大小1G,每次扩展128M
create tablespace tbs_xxxdba datafile '/opt/tbs_nps/tbs_xxxdba.dbf' size 1024M autoextend on next 128M maxsize unlimited;
#创建用户xxxdba
create user xxxdba identified by xxxdba default tablespace tbs_xxxdba;
#给用户xxxdba授权
grant connect, resource, select any table, create view, create synonym, create sequence,UNLIMITED TABLESPACE to xxxdba;
grant create session to xxxdba
#创建数据库DBLINK
create database link XXXDBA_LINK
connect to xxxdba identified by xxxdba_password
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.123)(PORT = 1521))) (CONNECT_DATA =(SID = sid001)(SERVER = DEDICATED)))';
查看数据文件位置
select name from v$datafile;