第一部分 客户化模块的建立
本章指导系统管理员如何创建客户化应用模块。
Warring :本章内容以个人测试环境为背景;在生产环境实施时需要作相应路径更改。第一步 Tablespace和User创建
11i环境:
-- create tablespace
CREATE TABLESPACE CUXD
DATAFILE '/u01/oracle/PROD/db/apps_st/data/cuxd.dbf'
SIZE 200M
AUTOEXTEND ON
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE CUXX
DATAFILE '/u01/oracle/PROD/db/apps_st/data/cuxx.dbf'
SIZE 200M
AUTOEXTEND ON
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
-- create the temp tablespace
/*CREATE TEMPORARY TABLESPACE temp
TEMPFILE '/u01/oracle/PROD/db/apps_st/data/temp.dbf'
SIZE 50M
AUTOEXTEND ON
NEXT 50M MAXSIZE 20480M
EXTENT MANAGEMENT LOCAL;*/
-- create user
CREATE USER CUX IDENTIFIED BY CUX;
GRANT CREATE SESSION,
CREATE TABLE,
CREATE PROCEDURE,
CREATE SEQUENCE,
CREATE TRIGGER,
CREATE VIEW,
CREATE SYNONYM,
CREATE TYPE,
CREATE DATABASE LINK,
ALTER ANY OUTLINE,
ANALYZE ANY,
QUERY REWRITE,
CREATE MATERIALIZED VIEW,
DROP ANY OUTLINE,
CREATE CLUSTER,
CREATE ANY OUTLINE,
ALTER SESSION
TO CUX;
GRANT resource to CUX;
--assign tablespace to user
ALTER USER CUX DEFAULT TABLESPACE CUXD QUOTA UNLIMITED ON CUXD;
ALTER USER CUX TEMPORARY TABLESPACE temp;
R12环境:
R12不需要自己创建tablespace,所有的应用都是在APPS_TS_TX_DATA下。
以DBA系统用户登录sqlplus:
sqlplus / as sysdba
SQL>create user cux identified by cux default tablespace APPS_TS_TX_DATA temporary tablespace TEMP;
SQL>grant connect ,resource to cux identified by cux;
第二步 目录结构建立
在目标服务器上依次建立以下目录结构