| Oracle/MySQL 관련 게시판 |
|---|
| 2014/03/14(23:54) from 180.65.248.176 | |
| 작성자 : 주인장 | 조회수 : 6139 , 줄수 : 66 |
| [오라클] ORA-06552: PL/SQL: Compilation unit analysis terminated |
|---|
|
요청한 작업을 수행하는 중 오류 발생: ORA-06552: PL/SQL: Compilation unit analysis terminated ORA-06553: PLS-553: character set name is not recognized 06552. 00000 - "PL/SQL: %s" *Cause: *Action: 업체 코드 6552 @ 조치내역 C:\>sqlplus "/as sysdba" SQL*Plus: Release 11.2.0.2.0 Production on 湲?3??14 23:49:54 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production SQL> update sys.props$ set value$ = 'AL32UTF8' where name = 'NLS_CHARACTERSET' 2 ; 1 row updated. SQL> update props$ set value$='AL32UTF8' where name='NLS_NCHAR_CHARACTERSET'; 1 row updated. SQL> select * from sys.props$ where name='NLS_NCHAR_CHARACTERSET'; NAME -------------------------------------------------------------------------------- VALUE$ -------------------------------------------------------------------------------- COMMENT$ -------------------------------------------------------------------------------- NLS_NCHAR_CHARACTERSET AL32UTF8 NCHAR Character set SQL> commit; Commit complete. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup; ORACLE instance started. Total System Global Area 644468736 bytes Fixed Size 1385488 bytes Variable Size 327158768 bytes Database Buffers 310378496 bytes Redo Buffers 5545984 bytes Database mounted. Database opened. SQL> Oracle SQL Developer에서 재시도 -> 테이블 생성 및 성공 |
|
|