oracle创建表空间脚本
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:为数据库用户名和密码
本文题目:oracle创建表空间脚本
转载来于:http://pwwzsj.com/article/piehcs.html