Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Snapshot Prob (cont'd) S.O.S., Help!
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