oracle 创建表空间和创建用户的语句

Create tablespace maximo datafile
'C:\oracle\product\10.2.0\oradata\maximo\maximo.dbf'
size 1000M autoextend on;


Create temporary tablespace maxtemp tempfile
'C:\oracle\product\10.2.0\oradata\maximo\maxtemp.dbf'
size 1000M autoextend on maxsize unlimited;


Create user maximo identified by maximo default tablespace maximo temporary
tablespace temp;
grant create job to maximo;
grant create trigger to maximo;
grant create session to maximo;
grant create sequence to maximo;
grant create synonym to maximo;
grant create table to maximo;
grant create view to maximo;
grant create procedure to maximo;
grant alter session to maximo;
grant execute on ctxsys.ctx_ddl to maximo;
alter user maximo quota unlimited on maximo;

原文地址:https://www.cnblogs.com/lingxzg/p/1587024.html