Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> error conversion db

error conversion db

From: supporto <supporto_at_tamautomazione.com>
Date: Thu, 14 Mar 2002 09:57:57 GMT
Message-ID: <Fu_j8.65199$Ns4.2724726@news2.tin.it>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US