Re: Export/Import

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Fri, 21 Sep 2001 09:13:57 -0400
Message-ID: <9ofeei$cqi9t$1@ID-85580.news.dfncis.de>

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

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

"Volodymyr Akselrod" <aksvladimir_at_hotmail.com> wrote in message news:aa90b006.0109210139.1ad4f1bb_at_posting.google.com...
> I want to export table emp from schema Scott to schema Laptop.
> Laptop has emp already. What's happen? All rows from laptop.emp are
> deleted and rows from scott.emp inserted?
> Can I append rows from scott.emp to laptop.emp using Export/Import?
>
> Regards!

If you use the IGNORE=Y option, it will insert the rows from the import into the latop.emp table. This used to be a common method to resize tables in Oracle7. Export it, drop it, recreate it with new size, import it with IGNORE=Y option.

-----BEGIN PGP SIGNATURE----- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBO6s8/2m5A4kkb4ZsEQL5TwCgx4OVDFYiCCaBVaRLf1Ag+JBfYNcAoJ5q PDZh6vwjn+vUAiWSRLcu/fUH
=/+Nz
- -----END PGP SIGNATURE----- -----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBO6s9Emm5A4kkb4ZsEQJgcQCfSKmMWP8DJYtkmC/HoPwb7flk2OMAoPHS BoWstapcve+o18xCYy9fsiUN
=b48p
-----END PGP SIGNATURE----- Received on Fri Sep 21 2001 - 08:13:57 CDT