RE: Import ora-03113 snapshots

Pozdravljen Vlado! Kako gre moji nekdanji firmi? Sta Robert Reinhardt in Ench
se zmeraj pri Asterju? Prosim te, daj ih lepo pozdravit.

The 3113 error means that your process lost the connection to the server process.
There should be another error in the alert_$ORACLE_SID.log and/or trace files in
the background_dump_dest and user_dump_dest. There are two things that come to mind:
a) 8.1.7.2 is buggy. Upgrade to 8.1.7.4. Search the readme.doc file for 8.1.7.4 for phrases like

   "export " and "materialized view". Search the metablink for related documents/bugs.
b) Check whether your target database has QUERY_REWRITE_ENABLED set to "TRUE" and

   QUERY_REQRITE_INTEGRITY set to "TRUSTED".

> -----Original Message-----
> From: Vladimir Barac [mailto:vladob_at_aster.si]
> Sent: Tuesday, August 06, 2002 11:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Import ora-03113 snapshots
>
>
> Hi, Listers!
>
> When I'm importing user export (export by system, imported
> also by system),
> import crashes with
>
> . importing VRT's objects into VRT
> IMP-00017: following statement failed with ORACLE error 3113:
> "CREATE SNAPSHOT "MV_PRID_VRT" USING
>
> What might be the problem? "MV_PRID_VRT" is materialized
> view, actually.
>
> All other user export / import cycles are going without
> problems, since
> those users (schema owners) don't have snapshots and
> materialized views.
>
> I have tried to create dummy table with the same name as
> snapshot's name, so
> import could skip importing snapshot. That didn't help...
>
> Linux Red Hat 6.2
>
> Oracle 8.1.7.2 Ent. Edition
>
> Please respond as soon as possible, since I'm stucked in the
> office due to
> this problem.
>
> Vladimir Barac
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Vladimir Barac
> INET: vladob_at_aster.si
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: MGogala_at_oxhp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).