Truncate all of the tables is maybe the easiest. Be sure to say "reuse
storage" option. But, with indexes already in place, it might take longer
than usual.
--
"Kathi" <katelynal_at_hotmail.com> wrote in message
news:c0b4b6dc.0308011840.b6e1af1_at_posting.google.com...
> 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 - 23:45:05 CDT
