Help ! Lost Contents of Long Raws

I have an Oracle database 7.3.3.4 running on HPUX 10 for the last year.

i have a table doc_store which stores my ms word docs and adobe pdfs. we use a powerbuilder front end to insert the docs and pdfs into database and also to export them for users to edit view. this has been working for last year no errors.

But, only last week we have been unable to retrieve our docs and pdfs from this doc_store table. The database integrity has been confirmed we have checked back over the alert logs etc and everything seems fine.

I am told the onlt way to verify the contents of the long raw columns are ok is to export the table which would show errors if corrupt.

Does anybody know how to extract/export the contents of my long raw columns form the database end ? any oracle utility to do this ?

we dont get any oracle errors at all from the client app when trying to extract the long raw. of maybe 100 rows in table maybe 10 can be viewed something that is curious is that can no longer calculate the size of the long raw
columns, we have some powerbuilder code that looks at the long raw and shows the size in bytes.

any ideas

Cheers

noel Received on Sun Mar 21 1999 - 11:40:19 CST