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

Alessandro Lagostena <alessandro.lagostena_at_tin.it> wrote in news:n3_se.40388$75.2215642_at_news4.tin.it:

> 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

Alternatively you could "pre-create" this tablespace manually with a smaller INITIAL size. If this is done then add the following onto the IMP command line
IGNORE=YES Received on Sat Jun 18 2005 - 15:01:00 CDT