Loading ...
Sorry, an error occurred while loading the content.

Re: Log Mining

Expand Messages
  • tony280352
    Hi, Tanx to Norm & Matthias My mistake was not to put a / at the beginning of the path I specified for utl_file_dir (running on a UNIX box). Silly bouy ...
    Message 1 of 5 , Jul 1 1:58 AM
    • 0 Attachment
      Hi,

      Tanx to Norm & Matthias

      My mistake was not to put a '/' at the beginning of the path I
      specified for 'utl_file_dir' (running on a UNIX box).

      Silly bouy ...

      Now I have built a Data Dictionary, I can have a further play

      Tanx again

      Tony


      --- In toad@y..., "kroll02" <matthias.kroll@s...> wrote:
      > Hi,
      >
      > here is a short script example for logminig:
      > EXEC sys.DBMS_LOGMNR_D.BUILD(DICTIONARY_FILENAME
      > => 'orcldict.ora',DICTIONARY_LOCATION => '/PDIS/FSG/FIAS/utl_file');
      > EXEC sys.DBMS_LOGMNR.ADD_LOGFILE(OPTIONS =>
      > sys.dbms_logmnr.NEW,LOGFILENAME
      => '/dev/EMDBD242/rOPFSG1.FSG001L1');
      > EXEC sys.DBMS_LOGMNR.ADD_LOGFILE(OPTIONS =>
      > sys.dbms_logmnr.ADDFILE,LOGFILENAME
      > => '/dev/EMDBD242/rOPFSG1.FSG002L1');
      > EXEC sys.DBMS_LOGMNR.ADD_LOGFILE(OPTIONS =>
      > sys.dbms_logmnr.ADDFILE,LOGFILENAME
      > => '/dev/EMDBD242/rOPFSG1.FSG003L1');
      > EXEC sys.DBMS_LOGMNR.START_LOGMNR
      > (DICTFILENAME => '/PDIS/FSG/FIAS/utl_file/logmr.sql'
      > ,STARTTIME => TO_DATE('10-Jan-2002 14:31:00', 'DD-MON-YYYY
      HH:MI:SS')
      > ,ENDTIME => TO_DATE('10-Jan-2002 14:34:00', 'DD-MON-YYYY
      HH:MI:SS'));
      >
      >
      >
      > SELECT sql_undo FROM sys.v_$logmnr_content
      > WHERE sql_undo IS NOT NULL
      >
      >
      >
      > regards matthias
    Your message has been successfully submitted and would be delivered to recipients shortly.