Re: Can't delete records from tables (Goes Not Responding).

You need to give more info.

A few suggestions:

When they are very large tables it might take a very long time. You can check this out by adding the following code to your WHERE-clause: WHERE rownum = 1.
This way your delete statement will return as soon as one row has been deleted.

If you are not using a WHERE-clause you might want to you use TRUNCATE instead of DELETE. TRUNCATE is very fast because it just changes the table's high water mark to 0.

Good luck,
Toine.

Henrik Meldgaard Frisk <news_at_group.inbox.as> schreef in berichtnieuws 8tjhpc$r0q$1_at_news.inet.tele.dk...
> Hi
>
> I have a serious problem in a Oracle8.0.4 Enterprise database on Unix.
>
> I have some tables in a database where it's not possible to delete any
 rows.
> I have even tryed from Oracle SQL Worksheet but even from here, I can't do
> it. (Goes Not Responding).
>
> I can easily post new records into the very same tables, but they just
 can't
> be deleted afterwards. The problem dos not affect all tables in the
 database
> but only a few ones. (about 5 tables).
>
> I have no idea why. Nothing has bin changes on the database resently.
>
> I really hope someone can help me here.
>
> Henrik
> Denmark.
>
>
Received on Mon Oct 30 2000 - 22:16:32 CET