Mark,
You can only use LogMiner to read redo log and archived log files.





Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----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

Oracle LazyDBA home page