Re: Help needed with Import/Export

Kathi wrote:

> Norman,
>
> Thanks for your helpful tip regarding the compress option. 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.
>
> Oh and yes, we've just started working on a migration to 8.1.7 - also
> not in support, I believe. Still, should be better than where we are.
> I'm sure that I will be hanging out here alot :P
>

If you've convinced them to migrate to 8i (8.1.7 is in full support until December) then try to convince them to consider going to Oracle9i (release 2) and using the 'compatibility' parameter for 8.1.7 equivalence. Might be an acceptable compromise <g>. Received on Mon Aug 04 2003 - 11:59:50 CDT