| I don't get tables redo records from logmnr_contents at 10g! [message #63316] |
Mon, 27 September 2004 06:34  |
Sami Zeitoun
Messages: 8
Registered: June 2004
|
Junior Member |
|
|
Hi all,
I am using Oracle 10.1.0.2.0 and I have the following problem:
I am running a query that should return the changes made to a specific table but I can only see the DDL changes and not the data changes!! i.e. I can't see INSERT/DELETE/UPDATE changes that I performed on the table!! Does anyone know why is that??
when I run the same query on Oracle 9.2 I get the right results!!
Thanks,
Sami.
|
|
|
|
|
|
| Re: I don't get tables redo records from logmnr_contents at 10g! [message #63318 is a reply to message #63317] |
Mon, 27 September 2004 07:11  |
Sami Zeitoun
Messages: 8
Registered: June 2004
|
Junior Member |
|
|
Thanks for the reply Frank.
I am doing this via SQL*plus. I ran the following:
begin
sys.DBMS_LOGMNR.ADD_LOGFILE('D:Oracleoradataora10gREDO01.LOG',sys.DBMS_LOGMNR.NEW);
sys.DBMS_LOGMNR.ADD_LOGFILE('D:Oracleoradataora10gREDO02.LOG');
sys.DBMS_LOGMNR.ADD_LOGFILE('D:Oracleoradataora10gREDO03.LOG');
end;
/
begin SYS.DBMS_LOGMNR.START_LOGMNR(
options =>SYS.DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG
);
end;
/
select * from v$logmnr_contents where seg_name = 'TABLE1';
I should have seen after that, the latest changes that I did on TABLE1 but nothing!! I got nothing!!
And as I said... at 9ir2 I got the info!!
Can anyone help me on this??
Thanks,
Sami.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
