SAP Knowledge Base Article - Preview

2165064 - Materialized view is disabled after a REORG REBUILD - SAP ASE

Symptom

  • You are running REORG REBUILD command on an ASE table used by a materialized view.
  • You can notice that the materialized view is marked as disabled.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) - All versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

precomputed result set, PRS, invalidated PRS, PRS refresh, PRS drop recreate, dependent object handling, DDL impact, schema versioning, plan invalidation, query plan recompile, post-maintenance tasks, database reorganization impact, rebuild operation impact, enable PRS, dependency tracking , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.