Re: Drop a table while you insert data into it !

Hi,

You cannot drop a table that has any rows locked (DML locks rows), because DROP TABLE requires an exclusive lock on the table.

To solve your problem, I would first look for a program. See V$ACCESS for the table name and find the session. Then see PROGRAM MACHINE TERMINAL from v$session for that SID.

Count the number of allocated extents in that table and set MAXEXTENTS. The program will get an error and stop.

Karen.

vani wrote:

> Here's the clarification.
>
> I want to drop a table while writing to it.
> This is a situation if the program is running for ever,
> and I can't kill the program.
> The table is growing and taking a lot of tablespace
> affecting the database performance.
>
> Thanks
> Vani
>
> * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful
Received on Fri Jul 21 2000 - 00:00:00 CDT