21 03 2018
IMP-00038: Could not convert to environment character set’s handle
- 에러
1 2 3 4 |
[ktest] /home/FILE]imp userid=nuriware/password@ktest file='tbccm03c_table.dmp' tables='tbccm03c' IMP-00038: Could not convert to environment character set's handle IMP-00000: Import terminated unsuccessfully |
- 해결
- 파일위치
[ktest] /home/FILE]ls
tbccm03c_table.dmp - 디레토리 생성
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
[ktest] /home/FILE]sqlplus SQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 21 13:44:20 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. Enter user-name: nuriware Enter password: Last Successful login time: Wed Mar 21 2018 13:42:52 +09:00 Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> create directory tabledump as '/home/FILE'; create directory tabledump as '/home/FILE' Directory created. |
이때 권한 확인
chown -R oracle:oinstall FILE
- 임포트
1 2 3 4 5 6 7 |
[ktest] /home/FILE]ls -al 합계 208 drwxr-xr-x. 2 oracle oinstall 31 3월 21 13:31 . drwxr-xr-x. 5 root root 45 3월 21 13:30 .. -rwxr-xr-x. 1 oracle oinstall 212992 3월 21 13:31 tbccm03c_table.dmp [ktest] /home/FILE]impdp userid=nuriware/password@ktest directory=tabledump dumpfile='tbccm03c_table.dmp' tables='tbccm03c' |
IOS app 인증 및 배포관련 iOS 에서 Swift에 FCM을 이용한 Push Topics 전송