how to kill a query from v$tables

From: Michael <moores_at_my-deja.com>
Date: Fri, 30 Jul 1999 15:04:06 GMT
Message-ID: <7nsesv$hj6$1@nnrp1.deja.com>

i'm creating these complicated SQL statements for migration of data to a new schema. when i execute a bad statement (no index found, cartesian join, etc) i can't stop it from a SQL/Net client (like SQLplus). i have just killed my session from within Enterprise Manager.

what's a better way of doing this? i'd like to kill the query directly without hacking out the entire session?

best regards,
--michael

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 30 1999 - 10:04:06 CDT