오라클 외부파일 실행

오라클에서 외부파일을 실행할 때 사용하는 OS유저와 패스워드는

$ORACLE_HOME/rdbms/admin에 저장되어 있는 externaljob.ora 파일을 참조함

보통의 경우 아래와 같이 저장됨

 

1  2	run_user = nobody run_group = nobody

 

오라클 계저정의

[oracle@ws_stg /app1/dbase/mig/direct]$ m_SECUI_SIGN_LOG_exp.sh Export: Release 10.2.0.4.0 - 64bit Production on Tuesday, 05 February, 2013 11:22:43 Copyright (c) 2003, 2007, Oracle.  All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Data Mining and Real Application Testing options ORA-31626: job does not exist ORA-31633: unable to create master table "MIGADMIN.MANUAL_JOB" ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT", line 871 ORA-00955: name is already used by an existing object

SQL> drop table SCHEMAEXP; Table dropped. SQL>  select OWNER_NAME, JOB_NAME, JOB_MODE,OPERATION from dba_datapump_jobs; no rows selected