Re: Simple Question for you all...

Depending on the sizes involved why not make a backup copy of the table first?

Create table tablename_backup as select * from tablename. <mess with the original table>
If it is not what you want, do a
Truncate table tablename
insert into tablename select * from tablename_backup.

( Not pretty or efficient in many cases, but it does the job for limited use)

Brian Peasland <dba_at_remove_spam.peasland.com> wrote:

>Unfortunately, there is no "truncate table" option for import. So you'll
>have to do one of two things. Either truncate the table before you do your
>import operation. Or drop the table and have import recreate it for you
>before importing the rows.
>
>HTH,
>Brian
>
>On Friday 24 October 2003 08:49, TheSensFan thoughtfully contributed:
>
>> 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!
Received on Fri Oct 24 2003 - 09:04:42 CDT