Re: Update a table

From: Mark Malakanov <markmal_at_sprint.ca>
Date: Sat, 3 Jul 1999 12:03:06 -0300
Message-ID: <Brqf3.1417$jl.11139988@newscontent-01.sprint.ca>

It will better truncate tables.
Because, if there is primary key or unique constraint, import will long time. Error will appeared for every row. If there is no prymary key or unique constraint, the rows will duplicated.

Mark

<rpdata_at_cyberus.ca> wrote in message
news:37766dab.309451732_at_news.cyberus.ca...
> Did you truncate the table in the second DB and set ignore=y on the
> import????
>
> Cheers,
>
> Robert Prendiun.
> On Sun, 27 Jun 1999 19:16:54 +0200, p6ms2t22_at_infop6.jussieu.fr wrote:
>
> >Hi !
> >
> >I have installed Oracle 8i for Linux on two PC and I created the same
> >database in each PC. I have updated the data of a table in the first PC
> >and i would like to import all this table to the second PC. I run exp
> >and then it creates an export file including this table.
> >
> >When i run imp with that file in the other PC, there is no error. But
> >when i control the table on this PC the data hadn't changed.
> >
> >Have you ever try to do that ? If yes how could i do ?
> >
> >Thanks for your attention.
> >
> >Bye !
> >
> >
> >
>
> #----------------------------------
> # RP Data Solutions Inc.
> # Oracle Database Support Services
> # Ottawa Canada +1(613)791-0599
> #----------------------------------
Received on Sat Jul 03 1999 - 10:03:06 CDT