Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> how to revoke dbms_logmnr.start_logmnr()

how to revoke dbms_logmnr.start_logmnr()

From: tracy <tracykim10_at_yahoo.com.hk>
Date: 12 Mar 2004 19:33:48 -0800
Message-ID: <5c91cce9.0403121933.5787e957@posting.google.com>

i run this sql to find out which user made changes to a table ( add a col):

   SELECT username,operation,sql_redo
    from v$logmnr_contents
      where operation = 'DDL'
SQL> from v$logmnr_contents

     *
ERROR at line 2:
ORA-01306: dbms_logmnr.start_logmnr() must be invoked before selecting from v$logmnr_contents

Pls tell me how to revoke dbms_logmnr.start_logmnr() .

TQ!

regards,
Tracy Received on Fri Mar 12 2004 - 21:33:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US