Database Administration (MOSC)

MOSC Banner

How to recreate materialized view log

in Database Administration (MOSC) 3 commentsAnswered

My current situation:

My primary production database is PROD. My data warehouse database is WAREPROD.

Materialized views in WAREPROD are based on tables in PROD. These materialized views are in the WARE_USER schema in WAREPROD.

The materialzed view logs in PROD are owned by the WARE_USER in the PROD database.

I am upgrading the application for my PROD database and the materialzed view logs are causing some issues. The application upgrade process can’t get past the point where it is checking the materialized view logs.

It is very much looking like the only way the application upgrade will run unfettered is to drop the WARE_USER id in the PROD database.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center