rupd$ in materialized view logs
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 26

Thread: rupd$ in materialized view logs

Hybrid View

  1. #1
    Join Date
    Feb 2007
    Posts
    212

    rupd$ in materialized view logs

    Dear Friends,

    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?

    Thanks

  2. #2
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    delete it, it means trouble.
    ---------------

  3. #3
    Join Date
    Feb 2007
    Posts
    212
    what? are u kidding papa rey...why the trouble

  4. #4
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    that means, it shouldn't be there. Only the MLOG$_.
    ---------------

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by reydp
    delete it, it means trouble.
    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
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    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.

  6. #6
    Join Date
    Feb 2007
    Posts
    212
    Quote Originally Posted by PAVB
    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
    hmmnn... I think papa rey just shared some exceptional problems negligible
    ones compared to lots of benefits oracle gives.

    Troubles using oracle can be attributed to the user himself or his
    knowhow about the product

  7. #7
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Quote Originally Posted by PAVB
    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
    ---------------

  8. #8
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by reydp
    But if you are to challenge if I really know the subject matter...
    I'm not Rey, I know you are good and, you have nothing to prove to me.

    Quote Originally Posted by reydp
    Nice try anyway, for pursuading Jen to hate me..... she's still nice to me..sorry
    Wasn't trying to do that. It's clear you have Jen eating from your hand.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    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.

  9. #9
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Quote Originally Posted by PAVB

    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.
    ---------------

  10. #10
    Join Date
    Feb 2007
    Posts
    212
    Quote Originally Posted by reydp
    delete it, it means trouble.
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width