Logminer not displaying right values

11-30  Source: Network gathering  Views:0 

Advertisement
Dear all,
10.2.0.4 on solaris 10
exec DBMS_LOGMNR.ADD_LOGFILE ('/arch/TABS2_133083_662754021.arc');
EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.COMMITTED_DATA_ONLY);
when v$logmnr_contents is queried, it is displaying the sql_redo and sql_undo as
insert into "UNKNOWN"."OBJ# 165170"("COL 1","COL 2","COL 3","COL 4","COL 5","COL 6","COL 7","COL 8") values (HEXTORAW('c410323d43'),HEXTORAW('706f7274616c'),HEXTORAW('c7150b04120a383a'),HEXTORAW('c120'),HEXTORAW('3137322e33302e302e3435'),HEXTORAW('3137322e33302e302e3435'),HEXTORAW('7075626c6963'),HEXTORAW('687474703a2f2f7777772e766976612e636f6d2e6b772f706f7274616c2f706167652f706f7274616c3f5f7061676569643d6e756c6c265f6461643d706f7274616c265f736368656d613d504f5254414c'));How do I get the exact insert statement ? (instead of the above binary values)
Kai
Edited by: KaiS on Apr 1, 2010 6:07 AM
What is object# 165170? Is it your table of interest?
Log miner produces the SQL necessary to undo the change and since it is using hex strings I would suspect one possible reason might be that all the columns in question are encrypted.
When you identify the object and list is create DDL that should identify if this guess is correct or not. If not then hopefully it will provide the necessary information to identify what you are seeing.
HTH -- Mark D Powell --
Related articles
  • Logminer not displaying right values 11-30

    Dear all, 10.2.0.4 on solaris 10 exec DBMS_LOGMNR.ADD_LOGFILE ('/arch/TABS2_133083_662754021.arc'); EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.COMMITTED_DATA_ONLY); when v$logmnr_contents is queried, it is displaying the sql_redo and sql

  • Captivate 4 shortens timeline - elements are not displayed right anymore 10-11

    Hi there, I already searched the forum but couldn't find an answer. Maybe someone of you can help me. I have a weird problem with the timeline – in short: it changes. I have some slides, based on imported Power Point slides. Within captivate I add so

  • Cost Sheet is not displaying condition values 11-30

    Hello All, When i am running the transaction code KGI2. System is calculating the Overhead values and updating the Actual Overhead cost for the Oder but it is not  displaying the values in the Cost Sheet, when we select Dialog display check box. Can

  • Display extra values not displaying extra value 11-30

    Hi, I have a SQL query that returns a LOV. I have "Display Extra Values" set to Yes. However, I don't see my "extra value" in the Select List. ?? Yet, when I check the session state, the value in the session state is the extra value. S

  • Loupe not displaying color values Aperture 3.4 11-30

    I've been having issues with the color value feature of the loupe disappearing although 'display color values' is checked.  It will stop working after I've been using it for a few hours without incident.  Sometimes fix itself if I quit Aperture, most

  • Mpower max 780 lightning UEFI not displayed right and windows 8.1 no DVI-input 10-11

    Hi all, I’m new to the forum, I’m very sorry that my first post is the posting of a problem. I’ve read several treads just to be sure I’m not asking the same question twice. In this case I have 2 problems, both are problems more users have issues wit

  • Dynamic Select List not displaying correct value 10-11

    Hi there! I have a page with a dynamic repeat region. As I press one record I get up all the details based on id on an edit page. The problem is that the info that is inserted via a Select List is not displaying correct on edit page. All the other va

  • Setting DAQ channel by property node does not display the value 10-11

    I am writing a configuration VI to set channel selection and calibration parameters for an SCXI chassis. I store a default setup in a configuration (ini) file and read that file automatically when the VI is called. The value from the file are set by

  • Filter not displaying all values 11-30

    When I attempt to filter a product code. the drop down list (under heading Expression) displays about 100 codes when in reality there are about 2000 values. I have changed the Maximum Rows per Page under Search Bar to 2000, but this still does not di

  • Pivot table not displaying the values correctly 11-30

    Hi, I have created a pivot table in which i am using 2 tables. I pulled columns from table A and one column from table B in the measures section to get the grand total. All the rows are comming fine but, its not returning any values for tableB's colu

  • Crystal Report V9 do not display decimal value HELP! 10-11

    <p>I have a field in Informix data type is Decimal(6,2)</p><p>when i used the field in the report, the decimal is not displayed</p><p>example: field1 = 305.50, in crystal report it only displayed 305.00, already setup the for

  • Fonts are not displaying right 10-11

    I'm creating a website with Muse and I need to use Scandic letters. But they don't seem to work. I've tried both web fonts and web safe fonts but the letters are still not displayed. I have closed Muse and relaunced it with no success. I'm using the

  • Output Preview does not show right values of Spots 10-11

    I have a document created in InDesign. It contains only 1 spot color (no CMYK). Acrobat shows worng spot values in Output Preview (100% for 100% spot, but 4% for 10% spot. Pitstop shows the right value. Can you tell me what is the problem?Hi Lisa, Fi

  • PC report S_E38_98000088 does not display periodic values 10-11

    Dear colleagues, In ECC6.0/new GL we are trying to use report  S_E38_98000088 to display Actual/Plan values for a specific month/period, but it looks like the system will always show a cumulative value since the beginning of the fiscal year. We enter

  • Off setting account not displaying any values in FBL3N AND FBLL03 10-11

    Hi Experts, We did customization and assigned Customer ,Vendor ,plant fileds as special fields in customization client ,which same are appearing in FBL3N and also FBLL03 but without any value. I post an entry Rent account Dr To Vendor account. If i s

  • Parent Child Dimension Not displaying Name value. 10-11

    I have a parent Child attribute in my dimension.  It show the correct ID value in the reports but when I change the value from the NameColumn to be something else it still only shows the ID value.  I have an identical case in another dimension and it

  • Spry horizontal menu's not displaying right in IE9 10-11

    Presently I'm using Dreamweaver CS4.  I have built a web site and placed a horizontal spry menu at the top of the web page.  It is situated on the page just below a smaller  non-spry horizontal menu.    In IE9, the menu appears above and to the right

  • EPub docs not displaying right 10-11

    I loaded a couple of ePub docs via iTunes, and neither displays correctly in iBooks. After the first page, there are a ton of blank pages. It seems to think that the books are 1000+ pages, which isn't right. They display fine on my nook. Has anyone t

  • Report not displaying all values 11-30

    Experts,   I am accessing BW report through portals .I have a variable  with drop down box in my report .When i click on the drop down box ,it is not showing only 200 values . but user want to see all  500 values in that drop down box.Is there any wa

  • JComboBox setSelectedIndex not displaying correct value 11-30

    Hi, Not sure if this is a bug or implementation issue. When trying to use the setSelectedItem(int) method of JComboBox, what's being displayed in the panel is not the same item that is selected when you open the dropdown. If you run the example code