Re: Delete Need help

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sun, 13 May 2001 23:35:25 -0700
Message-ID: <3AFF7CAC.C50BC735@exesolutions.com>

sean wrote:

> Hi There,
>
> my microsoft access takes a very long time to delete 20,000 records, from
> oracle linked table. Is there a easier way to delete these data directly
> from oracle itself ?
>
> TIA,
> sean

After laughing for awhile at your question I came to the conclusion that you have no idea what Oracle is. I would suggest that as long as you are connecting to a real industrial strength relational database from what is basically a toy you should go to http://otn.oracle.com and find the Oracle Concepts Manual and find out what Oracle is.

There is nothing you can do in Access you can not do faster and better and more securely in Oracle except crash.

Get yourself a book on PL/SQL and learn how to use SQL*Plus to accomplish your work correctly. To delete 20,000 records from a table in Oracle should take less than one second.

Daniel A. Morgan Received on Mon May 14 2001 - 01:35:25 CDT