One of the database was corrupted. So we have created clone of that database and performed recovery. We have imported records from this recovered file into new clone file.

This database is connected(relationship) to other database.e.g there are two database Department & employee database.These two table are created via DEPT_ID.I performed recovery on employee database.

 

Department	Employee
DEPT_ID	EMP_ID
DEPT_NAME	DEPT_ID
	EMP_NAME

Now When I create new employee for XYZ department.It is assigned to the another department.

How to solve this ?

 

I checked the recovery logs and did not find any errors but found this line

 

 

 

Is DEPT_ID set as an auto enter serial? And did you turn _off_ the update auto enter for the import?

Sounds like you have managed to re-number the DEPT_ID when you imported into the clone database....