Re: Import data

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 17 Jul 2007 11:54:57 -0700
Message-ID: <1184698495.95121@bubbleator.drizzle.com>

Sashi wrote:

>> 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

Look at two things ... first the docs ... you are asking basic syntax questions all covered in Morgan's Library at www.psoug.org and in Oracle's online docs at http://tahiti.oracle.com.

Second look at the TABLES keyword.

Also seriously consdier using DataPump as it is more sophisticated.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Jul 17 2007 - 13:54:57 CDT