http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [71]
02.File Book
File 자료실 [95]
Site Link [17]
개인폴더 [201]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [25]
MySQL [43]
DB2 [79]
ORACLE [3003]
PSQL [134]
기타정보 [155]
운영체제 [603]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: ORACLE

 회원가입

IMP-00058 ORA-01461 IMP-00028 ORA-29275 [ character set은 동일하게 하세요 ]
최길호 [LIST]   2009-08-28 02:47:40, 조회 : 34,859

exp 8.1.7.4 KO16KSC5601 NCHAR AL32UTF8
imp 9.2.0.6 KO16KSC5601 NCHAR UTF8

IMP-00058: ORACLE error 1461 encountered
ORA-01461: can bind a LONG value only for insert into a LONG column
IMP-00028: partial import of previous table rolled back: 2679 rows rolled back

http://kr.forums.oracle.com/forums/thread.jspa?threadID=894193&tstart=0

doc id: 788156.1 AL32UTF8 / UTF8 (Unicode) Database Character Set Implications
-----------------------------------------------------------------------------
In this Document
  Purpose
  Scope and Application
  AL32UTF8 / UTF8 (Unicode) Database Character Set Implications
     A) Often asked questions:
     A.1) Do I need to use Nchar, Nvarchar2 or Nclob?
     A.2) Does my Operating System need to support Unicode?
     A.3) What are the Unicode charactersets and the Unicode versions in Oracle RDBMS?
     A.4) Is -insert your preferred language here- supported in an Oracle Unicode database?
     B) Server side implications.
     B.1) Storage.
     B.2) How much will my database grow when going to AL32UTF8?
     B.3) Codepoints for characters may change in AL32UTF8.
     B.4) The meaning of SP2-0784, ORA-29275 and ORA-600 [kole_t2u], [34] errors / losing characters when using convert.
     B.5) Going to AL32UTF8 from another characterset.
     B.6) ORA-01401 / ORA-12899 while importing data in an AL32UTF8 database.
     B.6) Object and user names using non-US7ASCII characters.
     B.6) The password of an user can only contain single byte data in 10g and below.
     B.7) When using DBMS_LOB.LOADFROMFILE
     B.8) When using UTL_FILE
     B.9) When using sqlldr or external tables
     B.10) Make sure you do not store "binary" (Encrypted) data in character datatypes (CHAR,VARCHAR2,CLOB).
     B.11) String functions work with characters not byte (length,like,substr ...).
     B.12) LPad and Rpad count in "display units" not characters.
     B.13) Using LIKE and INSTR.
     B.14) Character functions that are returning character values might silently truncate data.
     B.15) Column size triple/quadruple when using Materialized Views / CTAS trough database link.
     B.16) When fetching data from non-AL32UTF8 databases using cursors (PL/SQL)
     B.17) When using HTMLDB.
     B.18) When using non-US7ASCII names in directory's or file names.
     B.19) When using XDB (xmltype).
     C) The Client side.
     C.1) Common misconceptions about NLS_LANG.
     C.2) Configuring your UNIX client to be an UTF8 (Unicode) client.
     C.3) Configuring your Windows client to be an UTF8 (Unicode) client.
     C.4) The default column width of output in sqlplus will change.
     C.5) Configuring your web based client to be a Unicode client.
     C.6) Using Sqlplus to run scripts in UTF-8 encoding
     C.7) Using Oracle Applications.
     C.8) Using Portal.
     C.9) Oracle Forms PDF and Unicode
     C.10) Changing a database to AL32UTF8 hosting an OracleAS 10g Metadata Repository.
  References


3.235.60.197


  LIST

제목 작성자 작성일 조회
Troubleshoot  IMP-00058 ORA-01461 IMP-00028 ORA-29275 [ character set은 동일하게 하세요 ]    최길호 2009/08/28 34859
Troubleshoot  ORA-16038, ORA-00354, ORA-00353, ORA-16014, Archiver process freed from errors. No longer stopped    최길호 2008/06/28 34711
Install and Config  Linux 4U5 MEM: 16G SGA: 8G [ 6시간 삽질 성공기, ORA-27102 ORA-00385 ERROR: Unable to attach to VLM segment WARNING: EINVAL creating segment ]  [2]  최길호 2008/06/29 34640
RAC,OPS  rac 10.2 change public IP , VIP , nic device [ vip evtf.log ( clsrevtf: Invalid resource attr ora.node1.vip ) ]  [6]  최길호 2008/09/16 34301
Tool  ociuldr 입니다. 유용하게 사용할 수 있을듯 합니다. [linux gcc, aix cc]   [1]  최길호 2010/01/27 34076
Troubleshoot  event enq: SQ - contention [ enqueue lock ]     최길호 2010/07/11 33921
Troubleshoot  create ctxsys [ 9i,10g ]    최길호 2011/04/16 33836
Troubleshoot  dbca LRM-00123 ORA-01078    최길호 2010/11/25 33819
Troubleshoot  ORA-04052 ORA-12154 IMP-00098: INTERNAL ERROR: impccr2    최길호 2009/04/01 33536
Troubleshoot  ORA-00600: 내부 오류 코드, 인수 : [12333], [12], [50], [48], [], [], [], []    최길호 2010/03/24 33305
Install and Config  11g 기본 설치 script [ create database script , 10g 가능 ]    최길호 2009/07/07 33248
Troubleshoot  /usr/lib/pa20_64/dld.sl: Unable to find library 'libsqlplus.sl' 'libwtc9.sl' 'libclntsh.sl.10.1'    최길호 2010/05/07 33158
Troubleshoot  ORA-07445: exception encountered: core dump [kghlkaftf()+128], ORA-00470: LGWR process terminated with error    최길호 2009/12/07 33060
Troubleshoot  opatch rollback후 OUI-67076    최길호 2007/07/11 32980
Tuning  DECODE 조건을 Index 사용할 수 있도록 SQL 변경    최길호 2010/05/11 32937
Troubleshoot  ORA-12705: Cannot access NLS data files or invalid environment specified    최길호 2010/10/01 32931
Script  login alter session 적용 [ trigger , alter session , 10046 event ]    최길호 2009/06/04 32861
Application Server  opmn java.lang.OutOfMemoryError 대처    최길호 2005/06/16 32843
Troubleshoot  HPUX, ORA-09968: scumnt: unable to lock file  [1]  최길호 2008/02/20 32627
Admin  segment shrink [ alter table ... shrink space; ]  [4]  최길호 2009/03/31 32455

    목록보기   이전페이지   다음페이지 [1][2][3][4] 5 [6][7][8][9][10]..[151]   [다음 10개]
       

Copyright 1999-2023 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
2021/06/30
윈도우 서버에서 sqlplus .... ORA-...
by 최길호
2021/06/30
ORA-28500: connection from O...
by 최길호
2019/05/02
pkg 확인 SELECT * FROM AL...
by 최길호
최근 게시물
12/01
[ORACLE]
dgmgrl 운영, db11st h/w 교체 시나리....
by 최길호
12/01
[ORACLE]
DGMGRL> show configuration;....
by 최길호
11/23
[운영체제]
arch filesystem 100% full 예방 /....
by 최길호