Help needed with Import/Export

I have a question which I am sure is fairly simple, but beyond my grasp at the moment. Our billing software is running on Oracle 7.3.4, HP Tru64 Unix 4.0G. Before the monthly billing run is started, an export is done with the following command -

imp user/password buffer=209715200 grants=n compress=y file=/data4/dumps/backup080103.dmp log=/data4/dumps/restore080103.log

Due to operator error, the run was started without all of the data loaded that needed to be billed. I want to do an import to put the database back to the place it was this morning. Other than attempting to perform the import, there has been no activity in the database.

I used the following command

imp user/password buffer=209715200 file=/data4/dumps/backup080103.dmp grants=n log=/data4/dumps/restore080103.log ignore=y full=y

which results in constraint errors.

All of the info I have seen on this group didn't address this kind of case where I just want to populate the tables with the old data. (I know this is oversimplifying.)

Any help would be greatly appreciated. Feel free to flame away due to our ancient database version - I'm trying to get our management to understand the ramifications.

Thanks,
Kathi Manley
Controller/DBA Received on Fri Aug 01 2003 - 21:40:21 CDT