|
안녕하세요...
답답한 마음에 이렇게 질문을 드립니다.
Oracle 8.1.7(HP-UX)에서 table 하나를 export 해서
Oracle 9i(Win XP)에서 다음과 같이 import했습니다.
근데 ORA-01659 에러가 뜨더군요. ㅡ.ㅡ;;
==============================================================================
D:\Temp>imp mfc/buta file=gentrdtd.dmp tables=gentrdtd
Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 -
Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
. importing MFC's objects into MFC
IMP-00017: following statement failed with ORACLE error 1659:
"CREATE TABLE "GENTRDTD" ("TRDSNO" NUMBER(4, 0) NOT NULL ENABLE,
"TRDCNO" VA"
"RCHAR2(8) NOT NULL ENABLE, "TRDTID" VARCHAR2(8) NOT NULL ENABLE,
"TRDTRDT" "
"VARCHAR2(8) NOT NULL ENABLE, "TRDTRTM" VARCHAR2(6) NOT NULL
ENABLE, "TRDCCN"
"T" NUMBER(10, 0) NOT NULL ENABLE, "TRDFLAG" VARCHAR2(4), "TRDGDT"
VARCHAR2("
"8), "TRDENO" NUMBER(4, 0), "TRDCTP" VARCHAR2(4), "TRDDIS"
VARCHAR2(4), "TRD"
"FIC" VARCHAR2(2), "TRDTRAM" NUMBER(7, 0), "TRDDREM" NUMBER(7, 0),
"TRDENEX""
" VARCHAR2(2), "TRDENTM" VARCHAR2(10), "TRDEXTM" VARCHAR2(10),
"TRDENSNO" NU"
"MBER(4, 0), "TRDEXSNO" NUMBER(4, 0), "TRDTCNT" NUMBER(8, 0),
"TRDNUM" NUMBE"
"R(7, 0), "TRDRID" VARCHAR2(10), "TRDTRTP" VARCHAR2(1), "TRDDCD"
VARCHAR2(1)"
", "TRDACD" VARCHAR2(8), "TRDSYST" DATE, "TRDTDIS" VARCHAR2(4))
PCTFREE 10 "
"PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL
2147483646 NEXT "
"1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0
FREELISTS 1 FREELI"
"ST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "MFC_DATA""
IMP-00003: ORACLE error 1659 encountered
ORA-01659: unable to allocate MINEXTENTS beyond 55 in tablespace
MFC_DATA
Import terminated successfully with warnings.
D:\Temp>
==============================================================================
그래서 여기저기 인터넷을 뒤져보니 Tablespace 크기가 맞지 않아
발생한다고 해서
Oracle 8.1.7(HP-UX)의 Tablespace 정보를 확인한 다음.
==============================================================================
TABLESPACE_NAME INITIAL_EXTENT NEXT_EXTENT
MIN_EXTENTS MAX_EXTENTS
------------------------------ -------------- -----------
----------- -----------
MFC_DATA 1048576 1048576
1 2147483645
PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING EXTENT_MAN
ALLOCATIO PLU
------------ ---------- --------- --------- --------- ----------
--------- ---
20 1048576 ONLINE PERMANENT LOGGING DICTIONARY
USER NO
==============================================================================
Oracle 9i(Win XP)에서 다음과 같이 Tablespace를 만들고,
사용자 mfc에 default Tablespace를 지정해 주고,
Tablespace정보를 확인해 봤습니다.
==============================================================================
create tablespace MFC_DATA
datafile 'mfcdata01.dbf' size 500M
default storage
( initial 1M
next 1M
minextents 1
maxextents 2147483645
pctincrease 20)
/
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT
NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------------------------ ---------- --------------
----------- ----------- -----------
MFC_DATA 4096 65536
1 2147483645
PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING EXTENT_MAN
ALLOCATIO PLU SEGMEN
------------ ---------- --------- --------- --------- ----------
--------- --- ------
65536 ONLINE PERMANENT LOGGING LOCAL
SYSTEM NO MANUAL
==============================================================================
Oracle 9i에서는 min,max extents외에는 지정한대로
Tablespace가
만들어지지 않았더라구염... ㅡ.ㅡ;;
혹시나 하는 마음에 import를 시켜봤지만 똑같은 에러가
발생합니다.
이 테이블은 15M정도 인데 150M짜리 테이블도 import해야 하눈뎅.
블럭사이즈가 영향을 주는 건지요? 해결방법이 없을까요??
끝까지 읽어주셔서 감사합니다... ^^*
p.s. 아.... Tablespace 생성을 여러번 했었는데, drop시킬 때
Offline을 시키지 않고
drop한 적이 2번있습니다. 혹시나 해서.. ㅡㅡㅋ
|
