Mark:

Can you try modify the script as follow to see if it will works...

dbms_logmnr.start_logmnr(DICTFILENAME=>'/a3u09/cs3/interface/outdata/DIC
TIONARY.ORA');

Thanks,

David C

------------------------------------------------------------------------
----
David Chiu

-----Original Message-----
From: Burris Mark
[mailto:oracledba-ezmlmshield-x45413045.[Email address protected]
Sent: Wednesday, November 29, 2006 5:09 PM
To: LazyDBA Discussion
Subject: RE: Log Miner on Unix 9i Database

I am using sqlplus with log miner. I have created the dictionary.ora
and assigned the alert logs I want to search. However when I run the
start log miner and the select statement I get an error expecting an
"INTO" parameter.





SQL> BEGIN

2
DBMS_LOGMNR.START_LOGMNR('/a3u09/cs3/interface/outdata/DICTIONARY.ORA');

3 SELECT SEG_NAME, SQL_REDO FROM V$LOGMNR_CONTENTS ;

4

5 DBMS_LOGMNR.END_LOGMNR;

6 END;

7 /

END;

*

ERROR at line 6:

ORA-06550: line 3, column 1:

PLS-00428: an INTO clause is expected in this SELECT statement





Frank



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




The information contained in this e-mail message, including any attachments, constitutes proprietary and confidential information
of Management Dynamics, Inc. and is intended only for the personal and confidential use of the recipient or recipients named above. If the reader of this message is not the intended recipient, you are hereby notified that you have received this message in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail and delete the original message.


Oracle LazyDBA home page