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

Just a quick note - if you do not have a tablespace of the same name in the target database as in the source, Oracle will create the schema object(s) in the tablespace assigned as default for the user you are importing as.

Regards,
Dana

"Maxim Demenko" <mdemenko_at_gmail.com> wrote in message news:d9367u$unp$01$1_at_news.t-online.com...
> Alessandro Lagostena schrieb:
> > 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
>
> Your error message has probably nothing to do with the initial extent
> size ( as they are relatively small and minextents = 1 ), so compress=n
> will produce the same error. The problem is , that by import you don't
> have tablespace named exactly as in the exported database ( or your
> target user don't have appropriated quotas on them). This behaviour does
> matter everytime as you import tables consising of more than one
> segment ( in your case - due to BLOB ). So, only ways to work around are
> a) Ensure that tablespaces with same name as initially are available and
> target user has enough quota on them
> b) As IANAL_VISTA suggested, precreate the table ( in this case you can
> use another tablespaces ) and import with IGNORE=yes
>
>
> Best regards
>
> Maxim
Received on Sun Jun 19 2005 - 09:57:53 CDT