Re: Newbie: Export/import only data

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Mon, 15 Oct 2001 15:47:33 -0400
Message-ID: <9qfegn$o95r5$1@ID-85580.news.dfncis.de>

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

"Oscar Arranz" <oscar.arranz_at_consors.es> wrote in message news:9qf7ed$5ab11_at_news1s.iddeo2.es...
> Hi everybody.
>
> I'm a newbie in Oracle administration. I have exported data
> from a table to a file but I don't know how to import this data to
> another database where the table already exists. I just want to
> update this database with the data from the first. Is exp / imp the
> right way ? How can I do it without recreating the table?
>
> Thanks in advance.
>
> Oscar.
>
>

Exp/imp is one way. Add the IGNORE=Y parameter to the import. That will ignore the creation error and import the data anyway. If it's a very large table, you might want to conider using COMMIT=Y also.

Another option is to use a database link, but this will not recreate indexes, grant permissions, etc. It will just copy the rows.

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

iQA/AwUBO8s9UWm5A4kkb4ZsEQIkXQCgnvF5qkb3BNtR9YTntIQwp0f8ZTUAniub Ht6UQqDsxhYG3wrWtMErpaQB
=MpTg
-----END PGP SIGNATURE----- Received on Mon Oct 15 2001 - 14:47:33 CDT