Re: Need help: Updating databases with imp

Hauke,

if the dumpfile from external database contains all the data you need then you can remove the data from youre existing database and import the data from the external. The existing and the extarnal database will then contain the same data. To be on the safe side: I would also make an export from the existing database just in case of... ;-) The IGNORE=Y parameter will cause the import to continue if an error occurs while creating a database object. It will, AFAIK, not import a row that already exists, since that would violate the primary key, or update an existing row.
Another option might be to create a second database with the dumpfile and update your existing database through databaselinks and some clever PL/SQL scripts.

h.t.h.
BertJan Meinders
Oracle DBA
ASR-ICT In article <8ubiq2$ffu$1_at_nnrp1.deja.com>,   Hauke Zuehl <hzuehl_at_my-deja.com> wrote:
> Hello folks!
>
> I have to update an existing database during night time. To do this I
> download the dump-File from an external server and import the file
 into
> the database running on our server.
>
> Let's say there is a table with a primary key and a value e.g. article
> number and a describing text.
> Now the article in our database is existing but there is a typo which
> was corrected and stored in the dump file. After importing the file
 the
> wrong article should be corrected.
>
> What is the parameter list for imp to do this or do I have to delete
> the table first?
>
> I read something about "IGNORE=Y" but is this really the right way?
>
> I hope you understood what my problem is and you have a hint for me :)
>
> Oh, btw: We are running Oracle 8.1.5 on a RedHat Linux system.
>
> Thanks and regards,
> Hauke
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 08 2000 - 07:23:59 CST