-
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
-
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
-
Thanks Thomas
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
-
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?
ngwh,
Singapore.
-
Hello
how can thsi be possible it should be there
/8.1.6/rdbms/admin/dbmslogmnrd.sql
please check once again.
regards
hrishy
-
another problem
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
-
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.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|