This content has been marked as final. Show 5 replies
I've been following that note from Mr.CKPT always and it used to work. This time god knows what went wrong.
I had a look at the note and also i used this query :
this gave me a checkpoint_change# which was way beyond the expected. so i brought that particular datafile from prod and restored on BCP. it worked.
select to_char( CHECKPOINT_CHANGE#),FILE# from v$datafile_header order by 1 desc;
Closing the thread.