Re: materialized views not exported

I think this is a known bug. The mviews that work are the boring, simple ones; the mviews that don't are the join and aggregate ones.

I don't remember which version of Oracle fixes it, but it might only be 9.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



bonminh lam wrote in message
<3c6b1bcf.0205020414.43a0d62a_at_posting.google.com>...


>We are using export/import (version 8.1.7) to replicate the production

>database to a test database.

>

>One problem we encountered is this: some of the schemata in the

>production instance have materialized views (or MViews for short)

>which are summaries of tables on the same schema, i.e, no database

>link is used in the query text. After the import into the test

>instance, we saw that there some of the MViews became simple tables.

>Some others do exist as MViews.

>

>The export and import were done using the OWNER option.

>

>Has any one come across this phenomena or know any explanation for it?