configure logminer

Posted on 2011-04-27
Last Modified: 2012-05-11
was trying to configure logminer
also I set in the pfile
manually created the directory also in C:\log_sunu_miner
SQL> alter system set utl_file_dir='C:\log_sunu_miner' scope=spfile;

System altered.
ISQL> show parameter utl_file_dir;

NAME                                 TYPE        VALUE                          
------------------------------------ ----------- ------------------------------
utl_file_dir                         string                                    
no value it is supposed to show the value..
Question by:nobleit
    LVL 76

    Accepted Solution

    You specified 'scope=spfile'. Yopu need to bounce the instance so the spfile is read.

    Some parameters can be set with 'scope=both' which is memory and spfile.
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    On mobile right now so cannot look it up but utl_file_dir is being phased out.  Not sure if it is still needed for logminer in newer versions.

    Please confirm this is necessary for your version.
    LVL 23

    Assisted Solution

    - here is a step by step to configure a logminer, if it helps:
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    Can I ask why you selected the answer you did?

    The question asked was why you cannot see the value of utl_file_dir.  That was answered in http:#a35480337.

    If you wanted a step-by-step guide on how to set up log miner, you should have asked that.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now