Re: Import data

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 17 Jul 2007 21:40:03 +0200
Message-ID: <f7j5uc$gge$1@news6.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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
>

DESTROY=YES (re-creates tablespaces - may work for you, may not) IGNORE=YES, in combination with truncate table - more work, but works all the time - no object invalidation

-- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGnRsTLw8L4IAs830RAuLEAJ9F7Pb+6EGEP7tj2PACFgXfA5rqMQCfeJfo sSE3e83P8P+CV2QmPmEUupk=
=Ilu/
-----END PGP SIGNATURE----- Received on Tue Jul 17 2007 - 14:40:03 CDT