Snapshot modification problem

From: Christophe Fonfrede <fonfrede_at_sycomore.fr>
Date: Wed, 16 May 2001 15:23:27 +0000 (UTC)
Message-ID: <3B029B87.598717AC@sycomore.fr>

Hello again,

Sometimes (hum, let's say "much too often"), when I :
- drop a snapshot and a snapshot log,

then recreate a snapshot log with different filter column, and recreate a snapshot (the first complete refresh works well)
try to refresh manually : execute dbms_snapshot.refresh('user.snap','f')

I get the error :

ORA-12018: following error encountered during code generation for "user"."snap"
ORA-00904: invalid column name
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 604
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 661
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 641
ORA-06512: at line 2

As the first complete refresh is ok, I don't understand why I can't refresh manually with the refresh procedure.

Well, how can I debug this ? Code generation ?? wow, sounds strange to me. Invalid column name ?? this one is even better : my tables do have the same columns exactly as before the drops, so it references some other dark system tables or views, but nothing should have changed. So which column is annoying me ?

What about the oracle documentation ? Let's see the description for ORA-12018 : "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."

Fine. I just have to correct the problem "invalid column name" ;)

I hope someone here can answer... and thanks a lot. If not, I'll try the "call support" answer, but I have some doubts...

-- 
Posted from [195.6.125.97] 
via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Wed May 16 2001 - 10:23:27 CDT