This content has been marked as final. Show 7 replies
- A - wrote:how is it that you can upgrade OS but not Oracle version?
we are running oracle 9iR2 ( 220.127.116.11.0) on windows server 2003 R2
V9 Oracle has been obsoleted & unsupported this Century.
Consider submitting Service Request to My Oracle Support.
Any other help?
I am not using RMAN.Do you have any kind of backup , Nothing Can be restore
How to recover payrol.slip table ?
Backup is not available because it is a new table.
try DBMS_REPAIR.CHECK_OBJECT to find corrupt blocks and then DBMS_REPAIR.FIX_CORRUPT_BLOCKS
Try the below docs. You can skip the corrupted blocks and recover the remaining data's in the table.
DBMS_REPAIR SCRIPT [ID 556733.1]
DBMS_REPAIR example [ID 68013.1]
Mark your Post as Answered or Helpful if Your question is answered.
Thanks & Regards,
Email : firstname.lastname@example.org
Thanks to all
specially Mihael and (StepIntoOracleDBA)