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

"Alessandro Lagostena" <alessandro.lagostena_at_tin.it> wrote in message 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

Export with compress=n
compress=y means it must fit into one extent (either method will remove chaining unless the row>block size)
Jim Received on Sat Jun 18 2005 - 13:58:10 CDT