I've got a data warehouse (oracle) where I need to set a column to the same value for all 700 million rows.
I don't have admin access, or access to an admin, so this needs to be accomplished with basic sql and no temp table creates.
Further complicating matters is if I try to just do a simple update where 1=1, it runs out of redo space.
The way I have it running right now is looping such as this:
loop update mytable set mycolumn = '1' where mycolumn is null and rownum < 50000; commit; end loop
but I know this is probably naive and there must be a quicker and more elegant solution.