Re: Deletes in Oracle 7

Gert Rijs wrote:
>
> Gary Mazzone wrote:
> >
> > Help
> >
> > I am trying to delete about 65000 records from a database >
 the delete wilth the following statement.
> >
> > delete from mgevents where bdate_time < '1-jan-96'

^^^^
So you disable key, because Oracle convert field bdate_time to string and then try to search conditions.

Try to do so :
 delete from mgevents where bdate_time < TO_DATE('1-jan-96,'dd-mmm-YY');

If this help you, please E-Mail me.

-- 
Vidmantas Matelis
http://www1.omnitel.net/vidma