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

Thread: mat view/snapshots v817, where is tlog$_ trigger?

  1. #1
    Join Date
    Apr 2000
    Location
    Charlotte, NC, USA
    Posts
    48

    Question

    creating mat view in 817 on nt. everything is cool, except that i don;t see trigger (tlog$_). like in 7 & 8. i see snapshot log mlog$_ table just fine.

    which dictionary table has trigger do u know?

    i have looked in dba_snapshot_logs and there is a column for it, but it is not populated, not in dba_triggers either. i have also looked for triggers on master table, no dice.

    any clues?

  2. #2
    Join Date
    Mar 2001
    Posts
    314
    Use the SYS.DBA_MVIEW* views. Maybe you will find the info there ?

    -amar

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