安装oracle后，新建表空间及用户的脚本
本文转载自http://tedeum.iteye.com/blog/1416519CREATE TABLESPACE TBSP_JSC DATAFILE [位置：'D:\oracle\product\10.2.0\oradata\JSC\JSC_data']SIZE 1024M AUTOEXTEND ON NEXT 256M MAXSIZE unlimited; CREATE TABLESPACE TBSP_JSC_TMP DATAFILE [位置：'D:\oracle\product\10.2.0\oradata\JSC\JSC_tmp']SIZE 1024M AUTOEXTEND ON NEXT 256M MAXSIZE unlimited; create user jsc identified by 123456; alter user jsc default tablespace TBSP_JSC quota unlimited on TBSP_JSC; alter user jsc temporary tablespace TBSP_JSC_TMP; grant create trigger to jsc; grant create session to jsc; grant create sequence to jsc; grant create synonym to jsc; grant create table to jsc; grant create view to jsc; grant create procedure to jsc; grant alter session to jsc; grant create job to jsc ; grant execute on ctxsys.ctx_ddl to jsc; --如果需要DBA权限 grant dba to jsc;
页:
[1]