Re: Ghost Data

Brandon,
do you know from which tables these 'ghost' entries are?
if yes, you can check the rowid of these values to make sure in which
datafile it is located.
Also if you drop your suspected tablespace BATEST, these data sould be still
accessable.

The next step will be creating block dumps of your datafile to check in
which blocks these strings are and if they are seen as 'used' or 'garbage'
from blockdump point of view.

I personally suspect some reused (and not wiped) buffer cache block, or any
other not wiped memory structure to be the cause.
This might only be a problem if you have to enable and enforce encryption of
some data and it gets dumped occasionally by this way into totally different
datafiles.


best regards,
 Martin

On Wed, Jul 1, 2009 at 01:35, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx>wrote:

>  hp50c.test01 /testdb/develop/test01/oradat ->strings batest.dbf
>
> Z[\]
>
> TEST01
>
> BATEST
>
>         14159.003    (<-- this data and all below except the last line were
> never entered into any table in this tablespace!)
>
> LABCORP337
>
> INSTALLATION
>
> Installation Services
>
> DEFAULT
>
> SERVICES
>
> DFLT
>
> BKIMBAL2
>
>
> . . .
>
> BA Row 1             (<-- here is the only data I actually entered)
>
>
>

Other related posts: