Do not include Oracle internal tables in snapshot/diff

Description

The following tables should be filtered from snapshots and excluded from diff operations:

  • MLOG$_* - Created by materliaized view logs for every table that is part of a materialized view. Not available for DDL operations.

  • RUPD$_* - Created by materialized view log tables using primary keys. Not available for DDL operations.

  • WM$_* - Workspace Manager backup tables.

  • CREATE$JAVA$LOB$TABLE - This table contains the name of the Java object, the date it was loaded, and has a
    BLOB column to store the Java object.

  • JAVA$CLASS$MD5$TABLE - This is a hash table that tracks the loading of Java objects into a schema.

Environment

Oracle

Reporter

Nathan Voxland

Fix versions

Affects versions

Priority

Major
Configure