Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie: Export/import only data

Re: Newbie: Export/import only data

From: Marc Blum <marc_at_marcblum.de>
Date: Mon, 15 Oct 2001 19:42:09 GMT
Message-ID: <3bcb3b48.4412004@news.online.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US