Oracle常用查询

--查询库是否存在

select tablespace_name,file_id,bytes,file_name from mshd_touchscreen; //查询库

--创建表空间

create tablespace SIMS_GUIDETOURS
datafile '/opt/oracle/oradata/testhmorcl/SIMS_GUIDETOURS.DBF' size 50M
autoextend on
next 10M
maxsize unlimited    //建表　

--创建用户并匹配表

CREATE USER sims_guidetours IDENTIFIED BY sims_guidetours
DEFAULT TABLESPACE SIMS_GUIDETOURS
TEMPORARY TABLESPACE temp;
grant dba,resource to sims_guidetours    //建用户，并匹配