ORA-01658: unable to create INITIAL extent during import of a db

Hello gents a have a proble when i try to export a dump from one db to a new

More in detail i have 2 istance of Oracle 8.1.6 on solarsi 2.7 (both on the same server)

Now i whant migrate the db from istance A) to istance B)

istance B) have sufficient space for contain all object of DB A) ( table index blobs)

I like export from A) with compress=y (as default) just to import data in compress and remove extents and chian.

In this condition when i try to import the DB on B) i obtain the follow errors :

IMP-00017: following statement failed with ORACLE error 1658:
"CREATE TABLE "SELECTORLIST" ("CLASSNAMEKEYA4" VARCHAR2(200), "IDA3A4"
NUMBE"
"R, "POLICYTYPE" VARCHAR2(30) NOT NULL ENABLE, "SELECTORLISTTYPE"
VARCHAR2(3"
"0) NOT NULL ENABLE, "SELECTORS" BLOB, "CREATESTAMPA2" DATE,
"MODIFYSTAMPA2""
" DATE, "CLASSNAMEA2A2" VARCHAR2(200), "IDA2A2" NUMBER,
"UPDATECOUNTA2" NUMB"
"ER, "UPDATESTAMPA2" DATE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
255 LO"
"GGING STORAGE(INITIAL 32768 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 4096
PCTIN"
"CREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USE"
"RS" LOB ("SELECTORS") STORE AS (TABLESPACE "BLOBS" ENABLE STORAGE IN
ROW C"
"HUNK 32768 PCTVERSION 10 NOCACHE STORAGE(INITIAL 1048576 NEXT 212992
MINEX"
"TENTS 1 MAXEXTENTS 1017 PCTINCREASE 1 FREELISTS 1 FREELIST GROUPS 1
BUFFER_"
"POOL DEFAULT))"

IMP-00003: ORACLE error 1658 encountered

Do you have any sudgestion for solve this problem or the only way is to export with compress=n than to create table before import ?

Thanks for the support

Regards LAGO Received on Sat Jun 18 2005 - 13:52:03 CDT