D Baldwin wrote:
> 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
Please do not top post.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sun Jun 19 2005 - 12:08:45 CDT
