Home » SQL & PL/SQL » SQL & PL/SQL » unable to run delete/update/insert statements on a table
unable to run delete/update/insert statements on a table [message #223315] Thu, 08 March 2007 07:48 Go to next message
Arpit
Messages: 99
Registered: March 2001
Member
hi there,

I'm stucked into a critical problem....I've to run a update statement (logic is very simple ) on a small no. of affected records (200) to a ORACLE TABLE and the statement is taking forever to complete. I had it running for around 30-60 minutes but no luck.....Now even if i try to run a update statement restricting to one record it takes for ever....

PLEASE HELP ASAP!!!!
Re: unable to run delete/update/insert statements on a table [message #223323 is a reply to message #223315] Thu, 08 March 2007 08:00 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
ONe thing you should do is:
posting the query and some information like OS/oracle version/...

Otherwise it's a pretty hard to determine what the problem is.
Re: unable to run delete/update/insert statements on a table [message #223324 is a reply to message #223323] Thu, 08 March 2007 08:02 Go to previous messageGo to next message
Arpit
Messages: 99
Registered: March 2001
Member
The Oracle backend is 8.1.7.4 Enterprise Edition.

The SQL statement that i need to run on PRODUCT TABLE is:

update product
set description = replace(description,'Ent Adv','Adv Ent')
where description like '%Ent Adv%';

/***At this point in time I cannot run update on any column or number of records*/
Re: unable to run delete/update/insert statements on a table [message #223331 is a reply to message #223315] Thu, 08 March 2007 08:11 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Another session has uncommitted transactions.
Previous Topic: Oracle internal error
Next Topic: Combine 2 columns
Goto Forum:
  


Current Time: Tue Dec 06 12:04:28 CST 2016

Total time taken to generate the page: 0.09045 seconds