"Edward Letendre" wrote:

> Okay, I have 4 tables that I need to load data into. I was thinking of using
> DTS to do the data load. The 4 tables already exist with old data. Some of
> the data in the text files is the same as the data in the tables.
>
> I have tried to disable to contraints on the tables and truncate the data
> (remove the data, but leave the structre intact if my oracle training is
> correct), but the one table with foreign key contraints will not be dropped
> or turncated.
>
> The other tables are successfully truncated and have their contraints
> diabled. What else can I do to get the last table truncated and get my data
> loaded, or should I even worry about truncating data before the data load.
> What would happen with duplicated rows? In theory, the data could be overrun
> or just added again, but I am not sure what to do.
>
> Helo a new DBA.
>
> Edward Letendre.