Shulou(Shulou.com)06/01 Report--

Oracle 10G script

CREATE TABLESPACE "UCXM_DATA" LOGGING DATAFILE'D:\ oracle\ product\ 10.2.0\ oradata\ ora\ UCXM_DATA01.ora'-- oracle installation path 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 UNLIMITEDEXTENT 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 4Mwitz-create CREATE USER "UCXM" PROFILE "DEFAULT" IDENTIFIED BY "DEFAULT TABLESPACE" UCXM_DATA "- set username and password 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"; Note: ucxm: user name and password for the database

Oracle 11G script

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 UNLIMITEDEXTENT MANAGEMENT LOCAL;CREATE TEMPORARY TABLESPACE "UCFC_TEMP" TEMPFILE'f:\ oracle\ oradata\ ora\ UCFC_TEMP01.ora' SIZE 150m REUSE AUTOEXTEND ON NEXT 50m MAXSIZE UNLIMITEDEXTENT MANAGEMENT LOCAL UNIFORM SIZE 4M -- create users (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" Note: ucfc: user name and password for the database

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.