| No required contents im view v$logmnr_contents [message #320271] |
Wed, 14 May 2008 08:45  |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
SQL> execute dbms_logmnr.ADD_logFILE('/u01/app/oracle/oradata/test/redo01.log');
PL/SQL procedure successfully completed
SQL> execute dbms_logmnr.ADD_logFILE('/u01/app/oracle/oradata/test/redo02.log');
PL/SQL procedure successfully completed
SQL> execute dbms_logmnr.ADD_logFILE('/u01/app/oracle/oradata/test/redo03.log');
PL/SQL procedure successfully completed
SQL> execute dbms_logmnr.ADD_logFILE('/u01/app/oracle/oradata/test/redo4.log');
PL/SQL procedure successfully completed
SQL> execute dbms_logmnr.start_logmnr(Options => dbms_logmnr.dict_from_online_catalog);
PL/SQL procedure successfully completed
SQL> select * from v$logmnr_contents where table_name='CB1' and seg_owner='ir1';
No record displayed though after starting logminer i update the row in CB1 table in ir1 schema
|
|
|
|
|
|
|
|
| Re: No required contents im view v$logmnr_contents [message #320296 is a reply to message #320277] |
Wed, 14 May 2008 10:32  |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
after doing log switch, when i am executing same sql
select * from v$logmnr_contents where TABLE_NAME='CB1' and seg_owner='IR1'
it is giving me following error
ORA-00600:internal error code, arguments:[krvxbpns01],[],[],[],[],[],[],[]
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
