Hi All,
When i try to import i am getting the below error.
i am using oracle 10g 10.2.0.4
ORA-01659: unable to allocate MINEXTENTS beyond 7 in tablespace
i checked the tablespace. its usage is very minimum. lots of free space exists. i dont know why i get this error!! can anyone pls help??
C:\Documents and Settings\SennJa01>imp ***** tables=chr_val_t
file=d:\chr_val_t_exp.dat touser=ogrds_dev
Import: Release 10.2.0.1.0 - Production on Fri Aug 6 10:47:51 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by OGRDSTEST, not by you
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export client uses US7ASCII character set (possible charset conversion)
. importing OGRDSTEST's objects into OGRDS_DEV
IMP-00017: following statement failed with ORACLE error 1659:
"CREATE TABLE "CHR_VAL_T" ("CHR_VAL_ID" NUMBER NOT NULL ENABLE, "CHR_VAL_COD"
"E" NUMBER NOT NULL ENABLE, "CHR_ID" NUMBER NOT NULL ENABLE, "NUMRC_VAL" NUM"
"BER, "UOM_ID" NUMBER, "DT_VAL" DATE, "DSCR_ONLY_FLG" VARCHAR2(1) NOT NULL E"
"NABLE, "CMRCLY_SNSTVE_FLG" VARCHAR2(1) NOT NULL ENABLE, "CPY_ITEM_VAL_FLG" "
"VARCHAR2(1) NOT NULL ENABLE, "INTRNL_USE_FLG" VARCHAR2(1) NOT NULL ENABLE, "
""EXCLUDE_FROM_HDNG" VARCHAR2(1) NOT NULL ENABLE, "AUTO_DFLT" VARCHAR2(1) NO"
"T NULL ENABLE, "AVAILABLE_FROM_DT" DATE NOT NULL ENABLE, "AVAILABLE_TO_DT" "
"DATE NOT NULL ENABLE, "CRTD_BY" VARCHAR2(50) NOT NULL ENABLE, "CRTD_DTTM" D"
"ATE NOT NULL ENABLE, "UPD_BY" VARCHAR2(50) NOT NULL ENABLE, "UPD_DTTM" DATE"
" NOT NULL ENABLE, "LCK_NUM" NUMBER NOT NULL ENABLE, "DEL_IND" VARCHAR2(1) N"
"OT NULL ENABLE, "CNSLDTD_ITEM_MOD" VARCHAR2(1) NOT NULL ENABLE, "MOD_TYP" V"
"ARCHAR2(1) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 "
"STORAGE(INITIAL 2348810240 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAUL"
"T) TABLESPACE "TS_OGRDS" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1659 encountered
*ORA-01659: unable to allocate MINEXTENTS beyond 7 in tablespace TS_OGRDS*
below is the code of the tablespace where i am importing the file
CREATE TABLESPACE TS_OGRDS DATAFILE
'/u01/app/oracle/oradata/OGRDSCHN/ts_ogrds1.dat' SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE 5120M
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;