Re: Import data

Sashi wrote:
> Hi All,
>
> I need to import data from an existing data dump file. The problem is
> that I need to overwrite existing tables. Since the import command
> doesn't give this option (very surprising), I'm wondering what to do.
> I don't want to drop all the tables as that might make my views,
> indexes etc go out of sync.
>
> Is there a way of keeping my tables and importing the existing data?
> The source and destination schemas are in sync.
>
> Thanks,
> Sashi
>

Truncate the table and then import with IGNORE=Y. This will remove the table's previous contents. The IGNORE=Y parameter will ignore the error when imp tries to create the table that already exists. The data will be imported into the now empty table.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com