Home » RDBMS Server » Server Administration » deleting records
deleting records [message #190436] Wed, 30 August 2006 13:36 Go to next message
superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico
Senior Member

I´m having problems when i try to delete some records in a table...

I'm doing follow:

delete from table where field like '04%';

and it seems like the computer work but nothing happens.

The table has about 10 millions of records.But i want to delete about 1800 records. I left the delete yasterday afternoon and in the morning the records are in the table.

I delete mi indexes too...

Something has an idea why is that?

thanks
ALex

[Updated on: Wed, 30 August 2006 13:57]

Report message to a moderator

Re: deleting records [message #190441 is a reply to message #190436] Wed, 30 August 2006 14:22 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
> I left the delete yasterday afternoon and in the morning the records are in the table.
Did you ever actually issue a COMMIT?
If no COMMIT, then the records will still exist.
Oracle performing as designed.
Re: deleting records [message #190443 is a reply to message #190441] Wed, 30 August 2006 14:24 Go to previous messageGo to next message
superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico
Senior Member

In fact the delete never finished...

I had to stop the delete....

Thanks men
Alex
Re: deleting records [message #190657 is a reply to message #190443] Thu, 31 August 2006 09:58 Go to previous message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
Depending on what server houses your database, it may take days to do a delete like that (Oracle running on a Windows machine like a P3 with 128 Mb memory).

With no index, a FTS on tens of millions of records on a slow PC is not desired.
Previous Topic: Installing Sql Client on Solaris
Next Topic: Tablespace
Goto Forum:
  


Current Time: Wed Dec 07 18:55:40 CST 2016

Total time taken to generate the page: 0.14610 seconds