RE: ** mv log
- From: Freeman Robert - IL <FREEMANR@xxxxxxxx>
- To: 'A Joshi ' <ajoshi977@xxxxxxxxx>, "'oracle-l-bounce@xxxxxxxxxxxxx '" <oracle-l-bounce@xxxxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx '" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 23 Nov 2004 14:48:26 -0600
Take a look at dba_dependencies and see if your MView log and related
dependencies live there. I'm not sure if mview logs with dependent mviews
are listed there or not and I can't test it just now.
RF
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
Sent: 11/23/2004 11:26 AM
Subject: ** mv log
Hi,
Recently I incresed the column length in a table that has a
materialized view log on it. Update to the column with increased length
is not working. I am planning to recreate the mv log. Before that I
would like to extract the mv log definition so I can use the same for
re-creating it. I want to be careful and follow the exact steps.
Anything else I need to do? I did find the table mlog$_<table_name>. I
assume this gets created when the mv log is created.
When I delete the mv log then I assume all objects that depend on the mv
log have to be complete refreshed. There could be objects in other
databases that depend on it and I do not know how to find those. What
would happen if I delete the mv log and recreate it and after that one
of the dependent objects tries to do a refresh. Will it get an error or
will it just changes after the re-creation. Thanks for your help.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
