DB/oracle12 docker / oracle 11g docker-compose yaml version: '3.7' services: oracle11g: image: oraclelinux:6 container_name: oracle11g volumes: - ./oracle-xe-11.2.0-1.0.x86_64.rpm.zip:/tmp/oracle-xe-11.2.0-1.0.x86_64.rpm.zip - ./init.sql:/tmp/init.sql - ./install.sh:/tmp/install.sh ports: - "1521:1521" environment: - ORACLE_ALLOW_REMOTE=true - ORACLE_PASSWORD=password command: /bin/bash -c "chmod 755 /tmp/install.sh && /tmp/install.sh && su - ora.. 2024. 2. 29. oracle / DEFAULT_TABLESPACE -- DEFAULT_TABLESPACE 조회 SELECT USERNAME, DEFAULT_TABLESPACE FROM USER_USERS WHERE USERNAME = '[유저명]'; 2022. 4. 14. oracle / sqlplus / UTF8 / 한글깨짐 1. 환경설정확인 # env | grep LANG NLS_LANG=KOREAN_KOREA.AL32UTF8 LANG=en_US.UTF-8 # 2.환경설정값 추가 # export NLS_LANG=KOREAN_KOREA.AL32UTF8 3. 설정값 확인 4. UTF8 로 sql저장 5. 파일 서버로 업로드 6. sqlplus로 실행 @파일명 2022. 1. 3. oracle xe [root@gs product]# echo $ORACLE_HOME /opt/oracle/product/18c/dbhomeXE [root@gs product]# echo $ORACLE_SID XE [root@gs product]# echo $ORACLE_BASE /opt/oracle [root@gs product]# export ORACLE_SID=XE export ORACLE_HOME=/opt/oracle/product/18c/dbhomeXE export ORACLE_BASE=/opt/oracle cd /opt/oracle/product/18c/dbhomeXE/bin /opt/oracle/product/18c/dbhomeXE/bin/exp 유저명/비밀번호 file=덤프파일명 owner=유저명 statis.. 2021. 2. 10. 이전 1 2 3 다음 반응형