Re: Help needed with Import/Export

Thanks for your suggestion - luckily I ended up not having to do the import after all. No activity had been done in the database since our tape backup, so we restored our system from that. Voila! as if the problem never occurred except for a little glitch involving a corrupted rollback segment. Dropped the other rollback segments, dropped the rollback tablespace because the corrupted rollback segment couldn't drop, then recreated the segments. Then recreated the tablespace/datafile with the 'reuse' option.

Regards,
Kathi Manley
Controller/DBA

"Burton Peltier" <burttemp1REMOVE_THIS_at_bellsouth.net> wrote in message news:<RaHWa.17032$BY2.6401_at_fe02.atl2.webusenet.com>...
> 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 Mon Aug 04 2003 - 10:59:36 CDT