Re: Recovery Manager (RMAN) problem

From: gazzag <>
Date: Tue, 3 Jun 2008 07:56:08 -0700 (PDT)
Message-ID: <>

On 3 Jun, 15:38, sati_82 <> 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

Original text of this message