oracle创建表空间脚本

oracle 10G 脚本

CREATE TABLESPACE "UCXM_DATA" LOGGING DATAFILE 'D:\oracle\product\10.2.0\oradata\ora\UCXM_DATA01.ora'    --oracle安装路径SIZE 150M REUSE AUTOEXTEND ON NEXT  50M MAXSIZE  10240M, 'D:\oracle\product\10.2.0\oradata\ora\UCXM_DATA02.ora'    SIZE 100M REUSE AUTOEXTEND ON NEXT  50M MAXSIZE  UNLIMITEDEXTENT MANAGEMENT LOCAL;CREATE TEMPORARY TABLESPACE "UCXM_TEMP" TEMPFILE     'D:\oracle\product\10.2.0\oradata\ora\UCXM_TEMP01.ora' SIZE 150M REUSE     AUTOEXTEND     ON NEXT  50M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL     UNIFORM SIZE 4M;--创建用户（oracle）CREATE USER "UCXM"  PROFILE "DEFAULT"     IDENTIFIED BY "UCXM" DEFAULT TABLESPACE "UCXM_DATA"       --设置用户名和密码    TEMPORARY TABLESPACE "UCXM_TEMP"     ACCOUNT UNLOCK;GRANT CONNECT TO "UCXM";GRANT RESOURCE TO "UCXM";GRANT SELECT ANY TABLE TO "UCXM";GRANT CREATE ANY TABLE TO "UCXM";GRANT SELECT_CATALOG_ROLE TO "UCXM";GRANT create trigger      to "UCXM";GRANT create procedure    to "UCXM";GRANT create type         to "UCXM";注：ucxm：为数据库用户名和密码

oracle 11G 脚本

CREATE TABLESPACE "UCFC_DATA" LOGGING DATAFILE 'f:\oracle\oradata\ora\UCFC_DATA01.ora' SIZE 150M REUSE AUTOEXTEND ON NEXT  50M MAXSIZE  10240M, 'f:\oracle\oradata\ora\UCFC_DATA02.ora' SIZE 100M REUSE AUTOEXTEND ON NEXT  50M MAXSIZE  UNLIMITEDEXTENT MANAGEMENT LOCAL;CREATE TEMPORARY TABLESPACE "UCFC_TEMP" TEMPFILE     'f:\oracle\oradata\ora\UCFC_TEMP01.ora' SIZE 150M REUSE     AUTOEXTEND     ON NEXT  50M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL     UNIFORM SIZE 4M;--创建用户（oracle）CREATE USER "UCFC"  PROFILE "DEFAULT"     IDENTIFIED BY "UCFC" DEFAULT TABLESPACE "UCFC_DATA"     TEMPORARY TABLESPACE "UCFC_TEMP"     ACCOUNT UNLOCK;GRANT CONNECT TO "UCFC";GRANT RESOURCE TO "UCFC";GRANT SELECT ANY TABLE TO "UCFC";GRANT CREATE ANY TABLE TO "UCFC";GRANT SELECT_CATALOG_ROLE TO "UCFC";GRANT create trigger      to "UCFC";GRANT create procedure    to "UCFC";GRANT create type         to "UCFC";

注：ucfc：为数据库用户名和密码