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!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vélez"
INET: oraclemavelgo_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Mon Jan 26 2004 - 17:54:26 CST