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