Re: how to revoke dbms_logmnr.start_logmnr()

From: (wrong string) ĝlskov Hansen <mmh_at_kab-bolig.dk>
Date: Sat, 13 Mar 2004 19:24:46 +0100
Message-ID: <40535086$0$1595$edfadb0f_at_dread14.news.tele.dk>


Should be
 Revoke dbms_logmnr from <user> ;

Regards
Martin M. Hansen

"tracy" <tracykim10_at_yahoo.com.hk> skrev i en meddelelse news:5c91cce9.0403121933.5787e957_at_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 Sat Mar 13 2004 - 19:24:46 CET

Original text of this message