Re: Import Question

Create a new schema..Then
Use the FROMUSER= and TOUSER= parameters and import the new data into the new schema...Then use Update statements to fix the existing schema's records where needed... ( like
update existinguser.table1 set field1 = ( select newschema.table1.field1 from newschema.table1 where existinguser.table1.key = newschema.table1.key); ) for instance..

"Jeff Boyer" <jdboyer@(remove)icomproductions.ca> wrote:

>Here is another good question..... I am using Oracle 8i and have a database
>with about 3500 records. I did an export for my client who sent that export
>off to another company here in Calgary. A new file was given back to our
>client with some added data in one of the fields. Our client wants this new
>data added to our existing database. The problem is that the data in the
>existing database has changed somewhat so an complete wipe out of the
>current database with new import will not work. Is there anyway to bring in
>the new data and append it to each corresponding record?
>
>I would appreciate any help you might have,
>Thanks
>Jeff
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Wed Jul 11 2001 - 15:20:40 CDT