ORACLE 新建数据库及用户

--创建表空间和数据库文件及默认表空间大小 
create tablespace StockSpace datafile '/data/oracle/oradata/orcl/stock.dbf' size 200m;
--设置数据库自动增长
alter database datafile '/data/oracle/oradata/orcl/stock.dbf' autoextend on;
--创建用户
create user stock identified by stock default tablespace StockSpace account unlock;
--给用户授权
grant create table,create view,create trigger, create sequence,create procedure to;
grant dba to stock;
--修改表空间大小
alter database datafile '/data/oracle/oradata/orcl/stock.dbf' resize 500m;