-
How about this:
UPDATE MASTNAME
SET LNAME = ''
WHERE LNAME = 'NONAME'
AND ROWNUM < 50000
/
commit
/
You can change the 50,000 to a higher number if you have the rollback. You will need to run this command many times of course. It should be more efficient than a cursor.
If you do the cursor option while the database is not being used by anyone then it will probably work. However it will take a long time. Like an entire weekend.
Have you looked at the Sun Netra Servers. It sounds like you are wasting you time with you current server, when you can spend 5 grand and get a real server that will work much better. There is not only the cost of a new server to consider there is the opportunity cost of not getting a new server that you should be thinking about. Plenty of RAM, Disk Space and Clock speed. It doesn't pay to skimp. Just my opinion.
-
In cases like this I like to:
1. create a table that has all my update keys with a "marker" type field.
CREATE TABLE jh$track_progress (
update_key varchar2(30),
start_ts date,
end_ts date)
2. Then, I populate the table with the update_keys I am interested in.
3. I write a pl/sql loop that does the following:
Code:
while [count of records with start_ts isnull > 0 ] loop
get the update key;
update jh$track_progress with start_ts = sysdate;
issue my update command;
update jh$track_progress with end_ts = sysdate;
commit;
end loop
[Edited by marist89 on 02-01-2002 at 01:47 PM]
-
Very interesting method Jeff... Thank you, I think I will try it.
As far as the server hardware itself goes, the government tends to be a bit slow and very cautious about replacing hardware. Beings this is a legacy system, it probably will not be replaced or ported to a new server until the current hardware breaks and cannot be repaired. I was not permited to copy the dump file to a outside location and run this script on beefier hardware.
-
They'll spend $1200 on a toilet seat, but you can't upgrade a computer. Will the wonders of the federal government ever cease? http://www.3dpcgame.com/cwm/s/otn/co...olconfused.gif
-
You got it... I don't even complain about it anymore... It doesn't do me any good and I get paid either way so I just accept the complete idiocracy of it all...
