RE: Ghost Data
Date: Wed, 1 Jul 2009 10:16:39 -0700
Message-ID: <64BAF54438380142A0BF94A23224A31E1128D50BC1_at_ONEWS06.oneneck.corp>
Hi Martin,
No, I don't know which tables they were from since I'm not that familiar with the application data. I could probably track it down if I needed too, although it might be impossible to tell for sure since some of the data, e.g. order numbers, probably exists in multiple tables. I don't see the point in checking the rowid and source datafile though - I know that the data is from somewhere else and is now showing up in my brand new datafile that I just created.
I'm not very familiar with block dumps and not sure if Oracle will dump blocks that it considers to be empty/unused since they aren't part of any segment yet - do you know if it will and if so, how do I do it? I'm still not sure what this would tell me either. There is no doubt that Oracle is putting data into this datafile where it doesn't belong so I don't need to verify that anymore - all I want to know is if this is normal behavior and why it does this. It's not really causing me any problems since I don't have any encryption requirements and my server is secured so nobody can go grepping through my datafiles anyway - I'm just curious.
Thanks,
Brandon
Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 01 2009 - 12:16:39 CDT