Re: Pls help me with this migration scenario..

On 26 Mar 2005 01:47:08 -0800, 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...
>

Your old data is inconsistent and you must have added constraints. You could clean up the old data or redefine the constraints to either set them to enable novalidate or trap rows failing the constraints into an exceptions table using the exceptions clause of the constraint clause.

>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 ?

Wouldn't make any difference. You are transporting a mess, how you transport it is irrelevant, it will stay a mess.

3 million rows is of course nothing.

>
>Thank you for your help,
>Krist

--
Sybrand Bakker, Senior Oracle DBA