Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Snapshot Prob (cont'd) S.O.S., Help!

Re: Snapshot Prob (cont'd) S.O.S., Help!

From: NetComrade <netcomradeNOSPAM_at_earthlink.net>
Date: Wed, 24 Nov 1999 00:42:35 GMT
Message-ID: <383b34f5.10979917@news.earthlink.net>


Well.. it was a bug..

Article-ID:         <PR:1016935.102>
Circulation:        PUBLISHED (EXTERNAL)<Help:KrStatus.PUBLISHED>
Platform:           GENERIC
Folder:             server.Rdbms.Distributed.Snapshots <Topics:4501>
Area:               RDBMS
Subject:            ORA-12018, ORA-00942, ORA-02063: ON CREATE
SNAPSHOT
Author:             TCOPELAN.US
Last-Updated:       21-OCT-99
Component:          RDBMS_V07.03.XX RDBMS_V08.01.XX

Problem Description:


 

When attempting to create a fast refresh snapshot from an 8.1 database to a
version 7.x database you get the following errors:

  ORA-12018: "following error encountered during code generation for
\"%s\"

      Cause: The refresh operations for the indicated snapshot could not be

             regenerated due to errors. See following error text. 
     Action: Correct the indicated problem and repeat the operation. 

  ORA-00942: "table or view does not exist"     (See Note:18536.1)

--OR--

  ORA-12018: "following error encountered during code generation for
\"%s\"

      Cause: The refresh operations for the indicated snapshot could not be

             regenerated due to errors. See following error text. 
     Action: Correct the indicated problem and repeat the operation. 

  ORA-00904: "invalid column name" 
      Cause: The column name entered is either missing or invalid.
     Action: Enter a valid column name.


Problem Explanation:


You may have hit bug:678268.

Oracle8i snapshots created with the fast refresh mode against an Oracle7 master site returns an ORA-12018 error.

Article-ID:         <PrSol:2064338.102>
For-Problem:        <Pr:1016935.102>
Circulation:        PUBLISHED (EXTERNAL)
Platform:           GENERIC
Folder:             server.Rdbms.Distributed.Snapshots
Subject:            USE WORKAROUND OR UPGRADE
Author:             TCOPELAN.US
Last-Updated:       21-OCT-99
Component:          RDBMS_V07.XX RDBMS_V08.XX

Solution Description:


The workaround for this situation is to create the snapshot with the refresh COMPLETE mode and then alter the refresh mode to fast using the 'alter snapshot' command.  

Solution Explanation:


 

This is an Oracle bug fixed in Oracle Release 8.1.6


Received on Tue Nov 23 1999 - 18:42:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US