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

Thread: snapshot logs

  1. #1
    Join Date
    Jan 2002

    snapshot logs

    Hi friends,

    In prevoius oracle db versions, i can create a snapshot log
    for a certain table based w/o primary key or by using the rowid.


    SQL> create snapshot log on EMP;
    ORA-12014: table 'EMP' does not contain a primary key constraint

    I always use this to store dml changes made against the table,
    while i am rebuilding/reorganizing it (based of rowid) and apply
    the changes after.

    Can u help me the new command to create a snapshot log based on
    a rowid pls?

    Thank u all in advance.

  2. #2
    Join Date
    Aug 2002
    Colorado Springs
    create materialized view log on emp with rowid;
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Jan 2002
    thanks my friend....more power to you

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.