[ The imperialist Japanese military must officially acknowledge and apologize for the coercion of young women into sexual slaves. / 幼い女性を性の奴隷にした帝國主義日本軍の?制性を公式に認め、謝罪しなければならない. ]

사용자

ID:
PW:

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

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

 회원가입

IMP-00003 ORA-32603: invalid FREEPOOLS LOB storage option value [ move lob table, lob index ]
최길호 [LIST]   2013-05-26 18:16:20, 조회 : 120,224

IMP-00017: following statement failed with ORACLE error 32603:
"CREATE TABLE "ACTIVITY2" ("ID" NUMBER(20, 0) CONSTRAINT "ACT2_ID_NOT_NULL" "
"NOT NULL ENABLE, "TRANSACTION_ID" NUMBER(20, 0) CONSTRAINT "ACT2_TRAN_ID_NO"
"T_NULL" NOT NULL ENABLE, "ACTIVITY_TYPE_ID" VARCHAR2(8) CONSTRAINT "ACT2_AC"
"T_TYPE_ID_NOT_NULL" NOT NULL ENABLE, "ACTIVITY_TYPE_NAME" VARCHAR2(100) CON"
"STRAINT "ACT2_ACT_TYPE_NAME_NOT_NULL" NOT NULL ENABLE, "PRODUCT_ID" VARCHAR"
"2(35) CONSTRAINT "ACT2_PROD_ID_NOT_NULL" NOT NULL ENABLE, "PRODUCT_TYPE" VA"
"RCHAR2(50) CONSTRAINT "ACT2_PROD_TYPE_NOT_NULL" NOT NULL ENABLE, "SUBJECT_I"
"NTERNAL_ID" VARCHAR2(35), "SUBJECT_EXTERNAL_ID" VARCHAR2(35), "SUBJECT_TYPE"
"" VARCHAR2(50), "CUSTOMER_ID" VARCHAR2(20), "CREATE_USER_ID" VARCHAR2(20) C"
"ONSTRAINT "ACT2_C_USER_ID_NOT_NULL" NOT NULL ENABLE, "CREATE_DATE" TIMESTAM"
"P (6) CONSTRAINT "ACT2_C_DATE_NOT_NULL" NOT NULL ENABLE, "ENTER_USER_ID" VA"
"RCHAR2(20), "ENTER_DATE" TIMESTAMP (6), "EXECUTE_USER_ID" VARCHAR2(20), "EX"
"ECUTE_DATE" TIMESTAMP (6), "STATUS" VARCHAR2(20) CONSTRAINT "ACT2_STATUS_NO"
"T_NULL" NOT NULL ENABLE, "PENDING_STATUS" VARCHAR2(20), "ACTIVITY_XML" CLOB"
", "RESULT_XML" CLOB) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE"
"(INITIAL 318767104 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLE"
"SPACE "ACCPDSAED" LOGGING NOCOMPRESS LOB ("ACTIVITY_XML") STORE AS (TABLES"
"PACE "ACCPDSAED" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION FREEPOOLS 65535"
" NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFE"
"R_POOL DEFAULT)) LOB ("RESULT_XML") STORE AS (TABLESPACE "ACCPDSAED" ENABL"
"E STORAGE IN ROW CHUNK 8192 RETENTION FREEPOOLS 65535 NOCACHE LOGGING STOR"
"AGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE error 32603 encountered
ORA-32603: invalid FREEPOOLS LOB storage option value
Import terminated successfully with warnings.

FREEPOOLS 65535 제거하면 테이블은 만들어진다. [ FREEPOOLS 65533 까지 가능 ]
imp ignore=y 해도 같은 에러 발생.

조치
alter table ACTIVITY2 modify lob (RESULT_XML) (freepools 1);
exp/imp
OR
use expdp/impdp

추가 move lob table
alter table UPA modify lob (RESULT_XML) (freepools 1);
alter table UPA modify lob (RESULT_XML) (shrink space cascade);
alter table UPA modify lob (RESULT_XML) (pctversion 0);
alter table UPA modify lob (RESULT_XML) (retention);
alter table UPA move tablespace LOB lob (SNAPSHOT) store as (tablespace LOB) parallel  16;
alter index OIM.IDX_UPA_GRP_EFF_TO_DT rebuild online parallel 8 tablespace OIMH;
select SEGMENT_NAME,TABLE_NAME,COLUMN_NAME from dba_lobs where TABLE_NAME='UPA';
select sum(bytes)/1024/1024 from dba_extents where segment_name='SYS_LOB0011974498C00006$$';

링크:
http://myoracle4u.blogspot.kr/2011/06/how-to-reorganize-reclaim-space-used-by.html
3.239.9.151


  LIST

제목 작성자 작성일 조회
Troubleshoot  ORA-03137: TTC    최길호 2018/04/24 1007007
WebLogic  weblogic cache    최길호 2018/02/28 237691
WebLogic  weblogic cluster session share [ 세션 공유 login.jsp login chk, weblogic.management.ManagementException: [Deployer:149188] ]    최길호 2018/03/03 124608
Troubleshoot  IMP-00003 ORA-32603: invalid FREEPOOLS LOB storage option value [ move lob table, lob index ]    최길호 2013/05/26 120224
Troubleshoot  proc, windows, vc 2003 , pcmake , Files\Microsoft은(는) 예상되지 않았습니다    최길호 2006/10/02 100261
Troubleshoot  dblink ORA-02068 ORA-03113 ORA-02080 [ ALTER SESSION CLOSE DATABASE LINK RDBNM; ]  [4]  최길호 2010/07/10 99054
Troubleshoot  ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1]    최길호 2021/09/23 98788
WebLogic   WEB-INF/lib 우선 적용, index-directory-enabled 인덱스 디렉토리    최길호 2018/02/27 97316
WebLogic  java -jar fmw_12.2.1.3.0_wls.jar The OpenJDK JVM is not supported on this platform.    최길호 2018/02/06 86610
Troubleshoot  TRIGGER,Function ORA-02069 ORA-06512 ORA-04088 ORA-02070    최길호 2008/12/19 86504
Script  session monitor [ dbms_xplan sql binds ]  [2]  최길호 2010/06/30 85394
Troubleshoot  ORA-03297 Resizing Empty Datafile    최길호 2009/08/11 84496
Admin  dd copy datafile raw device , filesystem  [4]  최길호 2009/09/07 81827
SQL,PL*SQL  dbms_random 사용예  [1]  최길호 2010/04/12 81288
Troubleshoot  ODBC {Microsoft ODBC for Oracle}, ORA-12154, ODBC NA000 IM006 01000  [1]  최길호 2008/01/04 77684
Troubleshoot  ORA-12537 , <unknown connect data> * 12537  [2]  최길호 2009/11/21 68019
Troubleshoot  ALTER SESSION CLOSE DATABASE LINK    최길호 2010/07/11 66248
Admin  ORACLE과 MSSQL간의 DBLINK 방법    최길호 2008/09/19 65350
Troubleshoot  ld: 0711-224 WARNING: Duplicate symbol: p_xargc    최길호 2010/06/08 65325
Tool  RAC jdbc connection test [ thin java test.java sample ]  [3]  최길호 2010/06/14 61906

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

Copyright 1999-2024 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 최길호
최근 게시물
03/04
[기타정보]
아두이노 wifi web test.
by 최길호
03/01
[기타정보]
아두이노 스마트하우스 V2.
by 최길호
02/28
[ORACLE]
plsql run sql from column / 테....
by 최길호