oracle 10G 脚本
![](/upload/ad_content/xuanchuantu-6.jpg)
三山网站制作公司哪家好,找
创新互联!从网页设计、网站建设、微信开发、APP开发、
成都响应式网站建设公司等网站项目制作,到程序开发,运营维护。
创新互联于2013年创立到现在10年的时间,我们拥有了丰富的建站经验和运维经验,来保证我们的工作的顺利进行。专注于网站建设就选
创新互联。
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:为数据库用户名和密码
另外有需要云服务器可以了解下创新互联cdcxhl.cn,海内外云服务器15元起步,三天无理由+7*72小时售后在线,公司持有idc许可证,提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案,具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势,专为企业上云打造定制,能够满足用户丰富、多元化的应用场景需求。
当前文章:oracle创建表空间脚本-创新互联
网页地址:
http://bjjierui.cn/article/desihi.html