logminer problem

[rakesh76]

dear friends

i am having oracle8i on winnt. i am trying for logminer packages. i am executing following program,

EXECUTE
DBMS_LOGMNR_D.BUILD('dictionary.ora',
'/oracle/database/',
options => DBMS_LOGMNR_D.STORE_IN_FLAT_FILE);

which is giving me error

identifier 'DBMS_LOGMNR_D.STORE_IN_FLAT_FILE' must be declared

can any body explain what mistake i did

is it oracle logminer viewer is available with oracle 8i ?
if it is how can i start.

Rakesh Sanghvi

[tomate]

hey rakesh,
The problem is that the package 'DBMS_LOGMNR_D' is not installed.
If you want to analyze your db, then you must execute the following script as sys:
dbmslogmnrd.sql with is in the file ORACLE_HOME\rbbms\admins.

But attention at this package there is an mistake.
in this script there gives a procedure named dbms_logmnr_d
and in this procedure is a varry named 'col_des_array' declared with must be increase to 700.

Than the package is ok and can be installed as sys.

Say if its now running please.

So long
Thomas Schmidt

[rakesh76]

Dear Thomas

Thanks for your reply. Thing is that dbms_logmnr_d package is already creaded in database, then also i will check again.
if it is not working then i will inform you again.

Rakesh sanghvi

Originally posted by tomate
hey rakesh,
The problem is that the package 'DBMS_LOGMNR_D' is not installed.
If you want to analyze your db, then you must execute the following script as sys:
dbmslogmnrd.sql with is in the file ORACLE_HOME\rbbms\admins.

But attention at this package there is an mistake.
in this script there gives a procedure named dbms_logmnr_d
and in this procedure is a varry named 'col_des_array' declared with must be increase to 700.

Than the package is ok and can be installed as sys.

Say if its now running please.

So long
Thomas Schmidt

[ngwh]

funny..i cant find any dbmslogminer.sql or somethg similar in my /admin/...directory? i am using 8.1.6 Solaris EE version...or is it a separate
purchase addition?

[hrishy]

Hello

how can thsi be possible it should be there

/8.1.6/rdbms/admin/dbmslogmnrd.sql

please check once again.

regards
hrishy

[rakesh76]

dear friends

i have created above package which is working perfectly.

when i am querying v$logmnr_contents , i am getting

object and hexadecimal value , what should i do for that if i want to display exacly sql statement , i have given following command ( i don't know whether is right or wrong)

dbms_logmnr.start_logmnr
( dictfilename=> 'c:\temp\AnalyzeRedo.log',options => DBMS_LOGMNR.NO_DICT_RESET_ONSELECT );

i am getting error component 'NO_DICT_RESET_ONSELECT' must be declared

what will be the soluation

Rakesh Sanghvi

[tomate]

Nice that it runs now.

The next problem i don`t know so right.

You write:
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
dbms_logmnr.start_logmnr
( dictfilename=> 'c:\temp\AnalyzeRedo.log',options => DBMS_LOGMNR.NO_DICT_RESET_ONSELECT );

i am getting error component 'NO_DICT_RESET_ONSELECT' must be declared
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

I think there lacks a procedure ('NO_DICT_RESET_ONSELECT' )
but i have never heard from it. What makes this procedure.

I know following
dbms_logmnr.start_logmnr
( dictfilename=> 'c:\temp\AnalyzeRedo.log', XXX);
and following XXX gives:
- startscn
- endscn
- starttime
- endtime
- dictfilename

and than you find the undo funktion in the v$logmnr_contents view under the column sql_red

I hope i could help you. Give a short answer if it runs or failed.

[rakesh76]

execute DBMS_LOGMNR.START_LOGMNR(OPTIONS =>
DBMS_LOGMNR.DDL_DICT_TRACKING +
DBMS_LOGMNR.NO_DICT_RESET_ONSELECT +
DBMS_LOGMNR.DICT_FROM_REDO_LOGS);

above statement i had copied from oracle documents , it is
giving me error which i had specified in my above reply.

(thanks everybody)
Rakesh Sanghvi