Re: Migration Workbench Problems
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