Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Generate ddl to create materialized view log..

khallas301Dec 5 2012 — edited Dec 6 2012

Hi gurus...

Oracle db: 11g

I am trying to generate / extract MVIEW Logs script from prod to apply on test.
I have tried
<code>
dbms_metadata.get_ddl(decode(object_type,'materialized_view_log'), object_name, owner)
from dba_objects
where owner=<ABC>;
</code>

above fails, any ideas?

thanks,

This post has been answered by unknown-7404 on Dec 5 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 3 2013

Added on Dec 5 2012

#general-database-discussions

10 comments

17,594 views