column session_info appear empty on logminer

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

 

-- 
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).