Re: Simple Question for you all...

TheSensFan wrote:

>I have a table in my Oracle database that I will be performing some updates
>on and would like to be able to revert back to the original table if the
>changes I make do not work.
>
>So far I am able to do an export of the table and import the table (using
>exp and imp). However, I can not seem to get the import to overwrite
>entries.
>
>From the looks of things I have to delete the old entries and then do an
>import.
>
>So I guess the short of it all is. Is there a way to import a table and
>force it to overwrite?
>
>Thanks!
>
>
>

Seems to me a far easier thing to do would be:

CREATE TABLE mytable_bak
PCTFREE 0
NOLOGGING
TABLESPACE <tablespace_name> AS
SELECT * FROM mytable;

Hard disk is hard disk. The backup table will take no more room than the export and be
both faster and simpler.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)