Re: Recovery Manager (RMAN) problem
Date: Tue, 3 Jun 2008 07:56:08 -0700 (PDT)
Message-ID: <36438816-241f-4ae0-9669-6aea28988c10@8g2000hse.googlegroups.com>
On 3 Jun, 15:38, sati_82 <krys_..._at_interia.pl> wrote:
>
> Thanks for your reply. Unfortunately neither user education nor DB
> constraints
> can be applied in such situation. The rollback mechanism is suppose to
> protect from a invalid data loading process. In the system users are
> able to load
> data from a file into DB. The most frequent error is that the file can
> include
> incorrect data (although the file structure and relations between data
> can be correct).
>
> Regards,
> Krystian
I appreciate that this may not be a problem of your own making, however, constraints exist to stop invalid data being loaded! Can you not convince your management that they're making a rod for their own backs? IMHO, once a database contains invalid data, it is completely useless. Oracle will spot an attempt to load bad data long before any alternative home-grown "solution" will. Guaranteed.
HTH -g Received on Tue Jun 03 2008 - 09:56:08 CDT