Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Import data

Re: Import data

From: Sashi <smalladi_at_gmail.com>
Date: Tue, 17 Jul 2007 10:15:17 -0700
Message-ID: <1184692517.847216.300700@g37g2000prf.googlegroups.com>


> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US