Home » Server Options » Replication » ORA-12004
ORA-12004 [message #74993] |
Mon, 29 January 2001 00:15 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Gawie Opperman
Messages: 9 Registered: August 2000
|
Junior Member |
|
|
Good afternoon,
We've got simple snapshots running, and they seemed to be fine (at least they where running without any hickups for a month now more or less) until one day some snapshots gave an ORA-12004 : REFRESH FAST cannot be used for snapshot. What can cause this? A complete refresh goes through fine. The other snapshots to other site on the same table works, it's only a few snapshots (4-6 out of 120) that isn't working.
Any suggestions would be appreciated.
Thanx
----------------------------------------------------------------------
|
|
|
Re: ORA-12004 [message #74994 is a reply to message #74993] |
Mon, 29 January 2001 03:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Eddie
Messages: 23 Registered: January 2001
|
Junior Member |
|
|
Hi,
Regarding the Oracle Documentataion:
----------------------------------------
ORA-12004 REFRESH FAST cannot be used for snapshot "string"."string"
Cause: The snapshot log does not exist or cannot be used.
Action: Use just REFRESH, which will reinstantiate the entire table. If a snapshot log exists and the form of the snapshot allows the use of a snapshot log, REFRESH FAST will be available starting the next time the snapshot is refreshed.
----------------------------------
Check the existence and validity of the snapshot logs on the master site.
Best regards,
Eddie
----------------------------------------------------------------------
|
|
|
Re: ORA-12004 [message #75504 is a reply to message #74994] |
Thu, 10 June 2004 10:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Shwan Mousawi
Messages: 1 Registered: June 2004
|
Junior Member |
|
|
you are doing a recursive SQL, ie in the from clause you are calling the table twice.
otherwise use this SQL and it will let you know what is going on
select ss.name mview_name
, ss.refresh_method mview_type
, ss.last_refresh
, mv.last_refresh_type
, decode(mv.refresh_method||mvj.operator_type
, 'FASTI' , 'Fast'
, 'FORCEI', 'Force'
, 'FASTR' , 'Fast Right Outter Join'
, 'FORCER', 'Force Right Outter Join'
, 'FASTL' , 'Fast Left Outter Join'
, 'FORCEL', 'Force Left Outter Join'
, mv.refresh_method||mvj.operator_type
) refresh_method
, mv.build_mode
, decode( ob.status
, 'VALID', decode( ss.cr_operations
, 'REGENERATE', 'Require Complete Refresh'
, 'VALID', decode( mv.compile_state
, 'VALID', decode ( mva.unusable
, 'Y', 'MV is Unusables'
, decode(mva.known_stale
, 'Y', 'Unusable After Refresh'
, 'N', 'Valid'
)
)
, 'Require Complete Refresh'
)
)
, 'Error in Object rebuild'
) Status
, log.master table_name
, log.log_table mvlog
, trigger_name
from all_snapshots ss
, all_mviews mv
, all_objects ob
, all_triggers trg
, all_mview_logs log
, all_mview_detail_relations mdr
, all_mview_analysis mva
, all_mview_joins mvj
where ss.name like 'ENTER MV NAME'
and ss.name = mv.mview_name
and ob.object_name = mv.mview_name
and ob.object_type = 'MATERIALIZED VIEW'
and mv.owner = ob.owner
and trg.table_name(+) = ob.object_name
and trg.owner(+) = ob.owner
and mdr.mview_name = mv.mview_name
and mva.mview_name = mv.mview_name
and mva.owner = mv.owner
and mvj.detailobj1_relation = mdr.detailobj_name
and mvj.mview_name = mv.mview_name
and mvj.owner = mv.owner
and log.master(+) = mdr.detailobj_name
|
|
|
Goto Forum:
Current Time: Sun Sep 08 15:30:18 CDT 2024
|