one of the datafiles was lost in a move !

and since this was a test database, I dropped the datafile and tablespace from the control file...so at this point the database has forgotten about the tablespace and datafile.

But, them my sys admin tells me he can get the file from a backup tape...we do have the arch files also.

I create a new tablespace, with the same datafile name that was lost...next I rename the orignal file (from backup) as the file of the tablespace that I just created. Then I did a checkpoint ! It complained about:

ORA-01122: database file 71 failed verification check
ORA-01203: wrong incarnation of this file - wrong creation SCN

Is this because the tablespace was created after the SCN of the datafile ?