Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Import data
> No version hmmmm. Your assumption that Oracle can not overwrite an
> existing table during an import is incorrect. Check out the DESTROY
> parameter athttp://tahiti.oracle.com.
> --
I did, and I think that helps.
When importing from a dmp file, Oracle seems to insist on creating
each table that it reads. I think it can be overridden so that table
creation errors are ignored. The option for this is IGNORE=Y. Am I
right?
By specifying destroy and ignore, I should be able to keep the
existing table schemas and overwrite the existing data, right?
Thanks,
Sashi
Received on Tue Jul 17 2007 - 12:15:17 CDT
![]() |
![]() |