Database Utilities (MOSC)

MOSC Banner

How to import materialized view data?

edited Oct 8, 2009 4:14AM in Database Utilities (MOSC) 15 commentsAnswered ✓
   Hi,

 

The dump files are generated by 9iR2 exp command and are imported by 11gR1 imp command.  There are three dump files: first one contains no rows and no constraints, second one contains rows without constraints, and third one contains only constraints.  There are three materialized views involved with each being associated with a table of identical name.  After importing all three dump files successfully with warnings (all warnings are associated with the materialized views)  I notice all materialized views contain no rows despite all of them and their tables are valid.  The database links used in creating the materialized views

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center