Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Simple Question for you all...
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 - 08:56:14 CDT