joe
Mauricio V�lez wrote:
Hello everybody
I normally have no problems with logminer.
The database es oracle 8.1.7.4.1 on Windows NT
but in this case the results show me the username and session_info columns empty
Here is the output:
(First I created log_detalle_giros_20040124 as select * from v$logmnr_contents where seg_name = 'GIROS')
SQL> select username,
2 to_char(timestamp, 'dd/mm/yyyy hh24:mi:ss'),
3 sql_redo,
4 session_info
5 from log_detalle_giros_20040124
6 where sql_redo like '%3420653%';
USERNAME TO_CHAR(TIMESTAMP,' SQL_REDO SESSION_INFO
-------- ------------------- ------------------------------ ------------
24/01/2004 11:48:47 update "LCA"."GIROS" set "CONS
ECUTIVO" = -3420653, "REMITENT
E" = 'AMINTA CAMACHO ROJAS', "
BENEFICIARIO" = 'ELVIA ROJAS D
E CAMACHO', "SECUENCIA" = 9304
38, "NUMERO_ORDEN" = '00930438
', "CODIGO_CORRESPONSAL" = '00
55', "CODIGO_CIUDAD" = '0004',
&nb! sp; "FECHA" = TO_DATE('23-ENE-200
4 10:24:07', 'DD-MON-YYYY HH24
:MI:SS'), "CODIGO_MONEDAR" = '
0012', "CODIGO_MONEDAE" = '000
2', "VALORR" = 852,44, "VALORE
" = 2299781, "TASA_DE_CAMBIO"
= 2697,88, "MENSAJE" = 'AUTORI
ZADO EL PAGO CON UN NOMBRE', "
CLAVE" = NULL, "TELEFONO1" = '
&nbs! p; 4118035', "TELEFONO2" = NULL,
"PAGADO" = 'S', "ACTUALIZADO"
= 'N', "ACTIVADO" = 'S', "OBSE
RVACIONES" = 'SE AUT PAG//NO S
AVE MONT/ES CLTE 18 OPER Y CON
F REMIT Y TLF SEG OF/JM.R.', "
INVESTIGACION" = 'N' where ROW
ID = 'AAAGHoAAOAACviHAAG';
So why do those columns appear empty on v$logmnr_contents?
Thanks
Mauricio V�lez
Oracle DBA
------------------------------------------------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. *Try it!* <http://us.rd.yahoo.com/evt=21608/*http://webhosting.yahoo.com/ps/sb/>
-- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the "CACHE"
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
