安装oracle后，新建表空间及用户的脚本
本文转载自http://tedeum.iteye.com/blog/1416519

CREATE 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;