Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie: Export/import only data
On Mon, 15 Oct 2001 19:46:52 +0200, "Oscar Arranz"
<oscar.arranz_at_consors.es> wrote:
>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.
>
>
you got to use the import parameters rows=y (which is the default) and ignore=y. that way imp proceeds even when the CREATE-statement fails, because the table already exists.
regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de
Received on Mon Oct 15 2001 - 14:42:09 CDT