Re: Logminer Help

From: Yttri, Lisa <lisa.yttri_at_cnh.com>
Date: Thu, 25 Jan 2001 09:14:00 -0600
Message-Id: <10752.127486@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C086E1.B2F20846
Content-Type: text/plain

Thanks to all who offered help. Once I set up the utl_file_dir parameter, the dictionary file was created with no problem.

Thanks also for the warning about bugs ........ I am trying to get this set up on an 8.1.5 database running on Solaris 2.6. If there's anything blatant that you're aware of, please let me know.

Thanks again -
Lisa

From: Joseph S. Testa
To: Multiple recipients of list ORACLE-L Subject: Re: Logminer Help
Date: Wednesday, January 24, 2001 5:26PM

Lisa, the dictionary file is used to resolve things like sys.tab$.obj# gets rsolved to its appropriate name.

you WANT a dictionary file.

as for the 6510, a couple of items, make sure you have the dictionary path is in the init.ora in the utl_file_dir entry, make sure the filename you pass is correct.

what version of database you have this on? there are more than a few bugs in logminer.

joe
> "Yttri, Lisa" wrote:
>
> Hi -
>
> I am trying to figure out how to use logminer. I have run the 2
> scripts to build the packages, but I am not sure what the purpose is
> of the dictionary file. When I try to run the dbms_logmnr_d.build
> script I am getting ORA-006510. I am passing a file name in single
> quotes and a directory name in single quotes.
>
> Can anyone help me figure out what to do - or point me to some good
> documentation?
>
> TIA -
> Lisa

--
Joe Testa http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com --
Author: Joseph S. Testa
INET: teci_at_oracle-dba.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
 --------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C086E1.B2F20846
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>Re: Logminer Help</TITLE>
</HEAD>
<BODY>

Thanks to all who offered help.  Once I set up = the utl_file_dir parameter, the dictionary file was created with no = problem.

Thanks also for the warning about bugs  ........ = I am trying to get this set up on an 8.1.5 database running on Solaris = 2.6.  If there's anything blatant that you're aware of, please let = me know.

<P><FONT SIZE=3D2>Thanks again -</FONT>
<BR><FONT SIZE=3D2>Lisa</FONT>
<BR><FONT SIZE=3D2>&nbsp;----------</FONT>
<BR><FONT SIZE=3D2>From: Joseph S. Testa</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Re: Logminer Help</FONT>
<BR><FONT SIZE=3D2>Date: Wednesday, January 24, 2001 5:26PM</FONT>
</P>

Lisa, the dictionary file is used to resolve things = like sys.tab$.obj#
 gets rsolved to its appropriate name.

you WANT a dictionary file.

as for the 6510, a couple of items, make sure you = have the dictionary
 path is in the init.ora in the utl_file_dir entry, = make sure the
 filename you pass is correct.

what version of database you have this on?  = there are more than a few
 bugs in logminer.

<P><FONT SIZE=3D2>joe</FONT>
<BR><FONT SIZE=3D2>&gt; &quot;Yttri, Lisa&quot; wrote:</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Hi -</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; I am trying to figure out how to use =

logminer.  I have run the 2
 > scripts to build the packages, but I am not = sure what the purpose is
 > of the dictionary file.  When I try to run = the dbms_logmnr_d.build
 > script I am getting ORA-006510.  I am = passing a file name in single
 > quotes and a directory name in single = quotes.
 >
 > Can anyone help me figure out what to do - or = point me to some good

<BR><FONT SIZE=3D2>&gt; documentation?</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; TIA -</FONT>
<BR><FONT SIZE=3D2>&gt; Lisa</FONT>
</P>

--
 Joe Testa  <A =
HREF=3D"http://www.oracle-dba.com" =
TARGET=3D"_blank">http://www.oracle-dba.com</A> Performing Remote DBA Services, need some backup DBA = support?
 For Sale: Oracle-dba.com domain, its not going cheap = but feel free to

<BR><FONT SIZE=3D2>ask :)</FONT>
<BR><FONT SIZE=3D2>&nbsp;--</FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =

HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2>&nbsp;--</FONT>
<BR><FONT SIZE=3D2>Author: Joseph S. Testa</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: teci_at_oracle-dba.com</FONT>
</P>

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051 San Diego, =
California        -- Public Internet = access / Mailing Lists
 <FONT =

SIZE=3D2>&nbsp;---------------------------------------------------------=

-----------
 To REMOVE yourself from this mailing list, send an = E-Mail message
 to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in
 the message BODY, include a line containing: UNSUB = ORACLE-L
 (or the name of mailing list you want to be removed = from).  You may Received on Thu Jan 25 2001 - 09:14:00 CST