Originally posted by mike9
In 9i you could do it over the external table feature ;-)
So in case your are looking for arguments to move from 8i to 9i this would be a good one (depending on how often you would use it)
Indeed -- with a combination of an external table + a MERGE statement, it'd be a one-step process.