오라클 815에서 817로 import시 에러메시지 입니다..
[oracle@daum oracle]$ imp oracle_dba/oracle_dba TABLES=ss01tt ROWS=Y file=pp001ss.dmp ignore=y
위와 같이 임포트실행시 아래와 같은 에러가 발생합니다...
-------------------------------------------------------------------------------------------------
Import: Release 8.1.7.0.1 - Production on Fri Sep 17 11:28:54 2004
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
Export file created by EXPORT:V08.01.05 via conventional path
Warning: the objects were exported by ENTER, not by you
import done in KO16KSC5601 character set and US7ASCII NCHAR character set
. importing ENTER's objects into ORACLE_DBA
IMP-00017: following statement failed with ORACLE error 1237:
"CREATE TABLE "PP001SS" ("N_SEQ" NUMBER(10, 0) NOT NULL ENABLE, "N_TITLE" VAR"
"CHAR2(100) NOT NULL ENABLE, "N_CON" VARCHAR2(4000) NOT NULL ENABLE, "U_ID" "
"VARCHAR2(8) NOT NULL ENABLE, "U_NO" NUMBER(10, 0), "U_CHK" VARCHAR2(1) NOT "
"NULL ENABLE, "N_DATE" VARCHAR2(8) NOT NULL ENABLE, "N_CODE" VARCHAR2(10), ""
"HIT" NUMBER(5, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING S"
"TORAGE(INITIAL 22120448 NEXT 11046912 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREA"
"SE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM"
"""
IMP-00003: ORACLE error 1237 encountered
ORA-01237: cannot extend datafile 1
ORA-01110: data file 1: '/oracle/oradata/ORCL/system01.dbf'
ORA-19502: write error on file "/oracle/oradata/ORCL/system01.dbf", blockno 63553 (blocksize=8192)
ORA-27072: skgfdisp: I/O error
Linux Error: 9: Bad file descriptor
Additional information: 63553
Import terminated successfully with warnings.
-----------------------------------------------------------------------------------------------------
테이블 하나만 임포트 시키는데도 에러가 나네요..
에러내용에 대한 고수님들에 답변 부탁드립니다...ㅡ.ㅜ
system tablespace를 조절해보시죠
system tablespace를 조절해보시죠
compress=n 함 해보심이
compress=n 함 해보심이
댓글 달기