凌寒飘香

____成风破浪会有时,直把云帆济沧海!

  博客园 :: 首页 :: 博问 :: 闪存 :: 新随笔 :: 联系 :: :: 管理 ::

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;

posted on 2009-10-20 16:52  凌寒飘香  阅读(981)  评论(0编辑  收藏  举报