DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: materialized view log

  1. 08-09-2002, 12:43 AM #1
    sona
    sona is offline Member
    Join Date
    Apr 2002
    Posts
    135
    hai,
    i created materialized view log for performing incremental refresh .
    Is there any way that i clear the log table then and there so that it will not occupy my storage space or will it clear by itself when refresh is over.
    will clearing it cause a problem
    Good Judgement comes from Experience.
    Experience comes from Bad Judgement
    Reply With Quote Reply With Quote
  2. 08-09-2002, 02:54 AM #2
    TimHall
    TimHall is offline Senior Advisor
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    It will clear itself once the refresh is complete.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width