Re:Configuration Admin Script 요청드립니다.
db서버에서 sys계정으로 접속하여 아래 문장을 실행하신 뒤에 오렌지 standard edition에 있는 orange configuration admin을 실행하여 system 계정으로 오렌지 스키마를 생성하시면 됩니다. ============================================================== CREATE ROLE ORANGE_MONITORING_ROLE ; CREATE OR REPLACE VIEW sys.ox$ktfbue AS SELECT * FROM sys.x$ktfbue ; CREATE OR REPLACE VIEW sys.ox$bh AS SELECT * FROM sys.x$bh ; GRANT SELECT ON sys.ox$ktfbue TO PUBLIC ; GRANT SELECT ON sys.ox$bh TO PUBLIC ; grant select on sys.ox$bh to orange_monitoring_role; grant select on sys.ox$ktfbue to orange_monitoring_role; GRANT EXECUTE ON sys.dbms_space_admin TO PUBLIC ; GRANT EXECUTE ON sys.dbms_space TO PUBLIC ; GRANT EXECUTE ON sys.dbms_system TO PUBLIC ; grant execute on dbms_space_admin to orange_monitoring_role; grant execute on dbms_space to orange_monitoring_role; grant execute on dbms_system to orange_monitoring_role;

---------- Original Message ----------
이름 : 박성환 제목 : Configuration Admin Script 요청드립니다.

--------------------------------------------------------
* Oracle Client (SQL*Net) Version : 10g * Oracle Server Version : 9.2.0.6 * Client OS : Win XP

--------------------------------------------------------
DB를 내릴수 없는 상황이라 Configuration Admin Script 요청드립니다. 수고하세요.