您好,登錄后才能下訂單哦!
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; --創(chuàng)建用戶(oracle) CREATE USER "UCXM" PROFILE "DEFAULT" IDENTIFIED BY "UCXM" DEFAULT TABLESPACE "UCXM_DATA" --設(shè)置用戶名和密碼 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:為數(shù)據(jù)庫用戶名和密碼
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; --創(chuàng)建用戶(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:為數(shù)據(jù)庫用戶名和密碼
免責聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。