Oracle基础SQL整理：创建表空间、创建用户、赋予DBA权限、建表

创建表空间

CREATE tablespace frdemo datafile '/tmp/frdemo.dbf' SIZE 128m autoextend ON NEXT 100m maxsize 1024m ;

创建用户及绑定表空间

CREATE USER fruser IDENTIFIED BY finereport DEFAULT tablespace frdemo;

给用户赋予dba权限

GRANT dba TO fruser;

创建表

CREATE TABLE t_owners(
id NUMBER PRIMARY KEY ,
name varchar2(30) ,
addressid NUMBER ,
housenumber varchar2(30) ,
adddate DATE ,
ownertypeid number
);