After trying to convert my db from sql server7 to oracle 8.1.7 with
migration workbench i have receive
1186 errors .... !!!!
i don't know how to resolve it .... please anyone can help me ?
CentriCo : Table. Owner name is NULL. Use the SQL Server 7
sp_changedbowner/sp_changeobjectowner procedure
to assign a valid login as owner of the table
EXCEPTION : SQLServer7SourceModelMap.mapForeignKeys(): CodGuast_FK00,
oracle.mtg.migration.MigrationSQLException: ORA-01400: cannot insert NULL
into ("SYS"."OM_FORN_KEY_INFO"."REF_OWNER") :ORA-01400: cannot insert NULL
into ("SYS"."OM_FORN_KEY_INFO"."REF_OWNER")
EXCEPTION : SQLServer7SourceModelMap.mapIndices(): Aggregazioni,
oracle.mtg.migration.MigrationSQLException: ORA-01400: cannot insert NULL
into ("SYS"."OM_INDEX_INFO"."TABLE_NAME") :ORA-01400: cannot insert NULL
into ("SYS"."OM_INDEX_INFO"."TABLE_NAME")
EXCEPTION : SQLServer7SourceModelMap.mapPrimaryKeys(): PKAggregati,
oracle.mtg.migration.MigrationSQLException: ORA-01400: cannot insert NULL
into ("SYS"."OM_OBJ_INFO"."OBJ_OWNER") :ORA-01400: cannot insert NULL into
("SYS"."OM_OBJ_INFO"."OBJ_OWNER")
EXCEPTION : SQLServer7SourceModelMap.mapTables(): Aggregati,
oracle.mtg.migration.MigrationSQLException: ORA-00903: invalid table name
:ORA-00903: invalid table name
thanks bye
Ale
Received on Thu Mar 14 2002 - 03:57:57 CST