oracle 10G 脚本
超过十余年行业经验，技术领先，服务至上的经营模式，全靠网络和口碑获得客户，为自己降低成本，也就是为客户降低成本。到目前业务范围包括了：网站设计制作、网站设计，成都网站推广，成都网站优化，整体网络托管，重庆小程序开发公司，微信开发，成都App制作，同时也可以让客户的网站和网络营销和我们一样获得订单和生意！
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：为数据库用户名和密码
