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 UNLIMITED
EXTENT 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 UNLIMITED
EXTENT 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:为数据库用户名和密码