initial extent and minextent

[remya_pn]

Hi,

I have created a new database and I want to import one schema to my new database. While importing I am getting the following errors. If anybody knows what the exact problem is, please help me soon..

Error regarding INITIAL EXTENT

IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace TS_ERIC
IMP-00017: following statement failed with ORACLE error 1659:

"CREATE TABLE "CON_KEY_TRANS" ("AGREEMENT_ID" VARCHAR2(15), "VERSION" NUMBER"
"(4, 0), "PRODUCT_NO" VARCHAR2(24), "REVISION_STATE" VARCHAR2(7), "VIA_ID" N"
"UMBER(10, 0), "TYPE_ID" NUMBER(38, 0), "PART_DATE_FROM" DATE, "CON_KEY" NUM"
"BER(10, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE("
"INITIAL 19398656 NEXT 8962048 MINEXTENTS 8 MAXEXTENTS 4096 PCTINCREASE 50 F"
"REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)


Error regarding MINEXTENT

IMP-00003: ORACLE error 1659 encountered
ORA-01659: unable to allocate MINEXTENTS beyond 3 in tablespace TS_ERIC
IMP-00017: following statement failed with ORACLE error 1659:

"CREATE TABLE "CON_SUB_OPTION_VALID_VALUES" ("OPTION_ID" NUMBER(10, 0),
"VALID_VALUE" VARCHAR2(250)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
LOGGING STORAGE(INITIAL 19398656 NEXT 8962048 MINEXTENTS 8 MAXEXTENTS 4096
PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "

This is the command I have given to create tablespace.

CREATE TABLESPACE TS_ERIC
DATAFILE 'ERIC01.DMP' SIZE 3072M
AUTOEXTEND ON MAXSIZE UNLIMITED
MINIMUM EXTENT 1K
DEFAULT STORAGE (INITIAL 1K NEXT 60K)
LOGGING;

I have read that this error can happen because of two reasons ie either tablespace size is small or extent size is too large. Here both extents I have given 1K. Also I added more datafiles into the table space. Even I am getting the same error.

Thanks in advance,
Remya

[Kamkan]

Hi,
use compress=n while importing.

[davey23uk]

compress is an export option, not an import one

but your tablespace is now too small to hold the data

[gamyers]

The tablespace is set to autoextend indefinately, so maybe you have run out of physical disk on that device (or the amount available to oracle).
Check the quota the user has on the tablespace too.