Re: Migration Workbench Problems

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Wed, 10 Sep 2003 21:30:11 -0700
Message-ID: <1063254591.506268_at_yasure>


Richard Crawford wrote:

> I've been breaking my head over this one for a couple of weeks now.
>
> The source database is an MS-SQL Server 7 database living on a Windows
> NT server; the destination is an Oracle 9i database living on Solaris
> 9.
>
> I've been trying to use the Oracle Migration Workbench to migrate the
> database, but after two weeks, I have had no success. At every
> attempt, I get the following error:
>
> "failed to map index :
> oracle.mtg.migration.MigrationSQLException: ORA-01400: cannot insert
> NULL into ("SA"."OM_INDEX_INFO"."TABLE_NAME") :ORA-01400: cannot
> insert NULL into ("SA"."OM_INDEX_INFO"."TABLE_NAME")"
>
> This is just the first in approximately 750 similar errors.
>
> I admit that I am at a loss. If anyone can offer any guidance, I
> would greatly appreciate it.
>
Please don't cross-post. Your question has already been answered in the appropriate forum.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu Sep 11 2003 - 06:30:11 CEST

Original text of this message