Re: Pls help me with this migration scenario..

On 26 Mar 2005, xtanto_at_hotmail.com wrote:
> Hi All,
>
> I am migrating Tables from SQL Server 2000 into Oracle 9i on AIX. In
> Oracle the tables have new structure.
> I have done OMWB so that now I have the data in Oracle , BUT still in
> old structure.
>
> So I do this :
> INSERT INTO [new structure]
> SELECT bla..bla.. FROM [old structure]
> (i have to do some manipulation on the old structure)
>
> The problem is : there is 3 million rows, and many times I get
> constraint error and I have to re-do the INSERT INTO... and get
> another error...
>
> So, what is the better scenario in this situation ?
> Should I export the [old structure] first (3 million rows) into TEXT
> and then use SQL Loader ?

First off, do you believe the sqlldr somehow bypasses constraints? You would get the same constraint errors. Constraint errors are your friend. What does the constraint error tell you? It tells you there are data quality issues in your source. You can,

1. Fix the data quality issues at the source then load.
2. Fix the data quality with views on the way in.

> Thank you for your help,
> Krist

-- 
Galen deForest Boyer