I created a materialized view log on on EMP. And It created me two tables
which are (MLOG$_EMP and RUPD$_EMP).
Whats the purpose of this RUPD$_EMP pls?
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
No offence but following that line of thinking I'm tempted to delete all my Oracle deployments, happens I got a lot of troubles using Oracle
I'm cool.
You're right. I stand corrected for that. No problem.
Maybe it's because I have used MatViews eversince it was first introduced but not lately. And that my line of thinking when this thread was open tends to recall only the obnoxious scenario rather than usual one.
But if you are to challenge if I really know the subject matter, you might try to search my archive posts here that tackles MatViews problem and issues. Long before you become a member of this forum.
Or, maybe have an exchange of ideas with the topic for examples:
"MAT VIEWS - best for DW/DM but never in OLTP", how's that.
Nice try anyway, for pursuading Jen to hate me..... she's still nice to me..sorry
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Wasn't trying to do that. It's clear you have Jen eating from your hand.
hmmm... I believe that includes you, and boris, and some of us here.
Anyway, for the Oracle Streams which boris mentioned, from what I know
the improvement was more in AQ(Advance Queueing), I remember problems using AQs in 9i/10g
where in queued process sometimes can't continue when let's say the db server gets down abnormally
and restarted. Then most of the recomendation was to use Streams specially
when the version is already in 10g. And from what I've read from Tamil, Streams are not yet stable
if you are going to use it specifically for Replication.
I can't delete it because it doesn't have any contents eversince it was
created do u mean drop the table dear?
I am curioous also because in all my readings about advance replication in
10g, I didnt come across topics about this rupd$...maybe its obsolete now?
Reply With Quote
are u kidding papa rey...why the trouble
Originally Posted by reydp
Bookmarks