oracle10 oracle / db link -- 해당유저에 db link생성권한부여 grant create database link to 유저명; grant create public database link to 유저명; grant drop public database link to 유저명; -- db link생성 -- public : 전체유저가 이용가능 -- 생략시 해당 생성유저만 이용가능 create public database link ORACLE1_sms connect to "원격유저명" identified by "원격유저비번" using 'ORACLE1'; create database link ORACLE1_sms connect to "원격유저명" identified by "원격유저비번" using 'ORACLE1'; ==>ORACLE1.. 2020. 4. 24. CentOS6.5 / Oracle11g / The listener supports no services 환경 [CentOS6.5 + Oracle11g] The listener supports no services vi $ORACLE_HOME/network/admin/listener.ora ## 아래 붉은색부분 추가 ------------------------------------------------------------------------------ SID_LIST_LISTENER = ( SID_LIST = (SID_DESC = (SID_NAME = ora11) (ORACLE_HOME = /oracle/product/11g) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (A.. 2020. 4. 24. oracle / random YYYYMMDD oracle 랜덤 날짜 구하기 UPDATE 테이블 SET 칼럼 = ROUND(dbms_random.value(2001,2014)) || TO_CHAR( ROUND(dbms_random.value(1,12)) , 'FM09') || TO_CHAR( ROUND(dbms_random.value(1,28)) , 'FM09') 2020. 4. 22. oracle / job / batch 참고 : https://docs.oracle.com/database/121/ARPLS/d_job.htm#ARPLS66560 1. 신규등록 DBMS_JOB.SUBMIT( job OUT BINARY_INTEGER, what IN VARCHAR2, next_date IN DATE DEFAULT SYSDATE, interval IN VARCHAR2 DEFAULT 'NULL', no_parse IN BOOLEAN DEFAULT FALSE, instance IN BINARY_INTEGER DEFAULT ANY_INSTANCE, force IN BOOLEAN DEFAULT FALSE ); ex) DECLARE job NUMBER; BEGIN DBMS_JOB.SUBMIT(job --자동생성 , 'DBMS_OUTPUT... 2020. 4. 17. 이전 1 2 3 다음 반응형