RE: Ghost Data
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: Martin Berger <martin.a.berger@xxxxxxxxx>, Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 1 Jul 2009 10:16:39 -0700
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.
Other related posts:
