# 이미지 검색하기 docker search oracle-xe # 이미지 당겨오기 docker pull jaspeen/oracle-xe-11g # 당겨온 이미지로 컨테이너 실행하기 docker run --name oracle11g -d -p 8080:8080 -p 1521:1521 jaspeen/oracle-xe-11g # 컨테이너 뜬 것 확인 docker ps # 도커 Oracle Instance Client 받기 docker pull store/oracle/database-instantclient:12.2.0.1 # 도커 SQLPLUS 실행 docker run -ti --rm store/oracle/database-instantclient:12.2.0.1 sqlplus {id}/{password}@{..

// JDBC 드라이버 // thin 사용할때 SID와 SERVICE_NAME 차이점 jdbc:oracle:thin:@{ipaddress}:{port}:{SID} jdbc:oracle:thin:@{ipaddress}:{port}/{SERVICE_NAME}

-- 다음 SQL문 실행 결과를 복사해서 실행한다. SELECT 'DROP TABLE "' || TABLE_NAME || '" CASCADE CONSTRAINTS;' FROM user_tables;

CREATE USER [계정이름] IDENTIFIED BY [계정비밀번호] DEFAULT TABLESPACE [테이블스페이스] TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; GRANT CONNECT, RESOURCE, DBA TO [계정이름]; GRANT CREATE DATABASE LINK TO [대상계정]; GRANT CREATE MATERIALIZED VIEW TO [대상계정]; GRANT CREATE PROCEDURE TO [대상계정]; GRANT CREATE PUBLIC DATABASE LINK TO [대상계정]; GRANT CREATE PUBLIC SYNONYM TO [대상계정]; GRANT CREATE ROLE TO [대상계정]; GR..