Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Migration of SQL Server 2000 Bombs - Log Attached

48869Oct 21 2001
Dear OTN,

I have repeatedly tried to migrate a MS SQLServer 2000
database to Oracle8.1.7 , using the 14101 Beta version of the
Migration Workbench and SQL Server 2000 plug-in. After reading
all there was on the subject, I upgraded my JVM to 1.1.8 and
capitalized all the table names in my SQL Server database.

The database structure appears to be captured, except for
the foreign keys. But when I try to create the Oracle database,
a long list of errors ensues as attached. Any insight into why
would be appreciated:
====================
Type: Information
Time: 20-10-2001 23:38:31
Phase: Capturing
Message: Begin Capture of Source Model

Type: Information
Time: 20-10-2001 23:38:31
Phase: Capturing
Message: Truncating Source Model

Type: Information
Time: 20-10-2001 23:38:35
Phase: Capturing
Message: Source Model truncated

Type: Information
Time: 20-10-2001 23:38:35
Phase: Capturing
Message: Truncated tables from MASTER database

Type: Information
Time: 20-10-2001 23:38:35
Phase: Capturing
Message: Source Model truncated

Type: Information
Time: 20-10-2001 23:38:41
Phase: Capturing
Message: Loading Source Model

Type: Information
Time: 20-10-2001 23:38:41
Phase: Capturing
Message: Loading tables from MASTER database

Type: Information
Time: 20-10-2001 23:38:43
Phase: Capturing
Message: Loading SS2K_SYSDATABASES

Type: Information
Time: 20-10-2001 23:38:44
Phase: Capturing
Message: Loading SS2K_SYSLOGINS

Type: Summary
Time: 20-10-2001 23:38:45
Phase: Capturing
Message: 7 rows inserted into table SS2K_SYSDATABASES

Type: Summary
Time: 20-10-2001 23:38:45
Phase: Capturing
Message: 3 rows inserted into table SS2K_SYSLOGINS

Type: Information
Time: 20-10-2001 23:38:45
Phase: Capturing
Message: Loaded tables from MASTER database

Type: Information
Time: 20-10-2001 23:38:45
Phase: Capturing
Message: Loading Source Model For ONRPET

Type: Information
Time: 20-10-2001 23:38:45
Phase: Capturing
Message: Loading SS2K_SYSUSERS

Type: Information
Time: 20-10-2001 23:38:45
Phase: Capturing
Message: Loading SS2K_SYSPERMISSIONS

Type: Summary
Time: 20-10-2001 23:38:45
Phase: Capturing
Message: 16 rows inserted into table SS2K_SYSUSERS

Type: Summary
Time: 20-10-2001 23:38:45
Phase: Capturing
Message: 80 rows inserted into table SS2K_SYSPERMISSIONS

Type: Information
Time: 20-10-2001 23:38:46
Phase: Capturing
Message: Loading SS2K_SYSPROTECTS

Type: Summary
Time: 20-10-2001 23:38:47
Phase: Capturing
Message: 197 rows inserted into table SS2K_SYSPROTECTS

Type: Information
Time: 20-10-2001 23:38:48
Phase: Capturing
Message: Loading SS2K_SYSMEMBERS

Type: Information
Time: 20-10-2001 23:38:48
Phase: Capturing
Message: Loading SS2K_SYSFOREIGNKEYS

Type: Information
Time: 20-10-2001 23:38:48
Phase: Capturing
Message: Loading SS2K_SYSCOMMENTS

Type: Information
Time: 20-10-2001 23:38:48
Phase: Capturing
Message: Loading SS2K_SYSCOLUMNS

Type: Summary
Time: 20-10-2001 23:38:48
Phase: Capturing
Message: 3 rows inserted into table SS2K_SYSMEMBERS

Type: Information
Time: 20-10-2001 23:38:48
Phase: Capturing
Message: Loading SS2K_SYSOBJECTS

Type: Summary
Time: 20-10-2001 23:38:48
Phase: Capturing
Message: 22 rows inserted into table SS2K_SYSFOREIGNKEYS

Type: Information
Time: 20-10-2001 23:38:48
Phase: Capturing
Message: Loading SS2K_SYSREFERENCES

Type: Summary
Time: 20-10-2001 23:38:49
Phase: Capturing
Message: 22 rows inserted into table SS2K_SYSREFERENCES

Type: Information
Time: 20-10-2001 23:38:49
Phase: Capturing
Message: Loading SS2K_SYSFILES

Type: Summary
Time: 20-10-2001 23:38:49
Phase: Capturing
Message: 2 rows inserted into table SS2K_SYSFILES

Type: Information
Time: 20-10-2001 23:38:49
Phase: Capturing
Message: Loading SS2K_SYSINDEXKEYS

Type: Summary
Time: 20-10-2001 23:38:50
Phase: Capturing
Message: 135 rows inserted into table SS2K_SYSCOMMENTS

Type: Information
Time: 20-10-2001 23:38:50
Phase: Capturing
Message: Loading SS2K_SYSCONSTRAINTS

Type: Summary
Time: 20-10-2001 23:38:51
Phase: Capturing
Message: 40 rows inserted into table SS2K_SYSCONSTRAINTS

Type: Information
Time: 20-10-2001 23:38:51
Phase: Capturing
Message: Loading SS2K_SYSTYPES

Type: Summary
Time: 20-10-2001 23:38:51
Phase: Capturing
Message: 147 rows inserted into table SS2K_SYSINDEXKEYS

Type: Information
Time: 20-10-2001 23:38:51
Phase: Capturing
Message: Loading SS2K_SYSINDEXES

Type: Summary
Time: 20-10-2001 23:38:51
Phase: Capturing
Message: 26 rows inserted into table SS2K_SYSTYPES

Type: Summary
Time: 20-10-2001 23:38:51
Phase: Capturing
Message: 114 rows inserted into table SS2K_SYSOBJECTS

Type: Summary
Time: 20-10-2001 23:38:52
Phase: Capturing
Message: 148 rows inserted into table SS2K_SYSINDEXES

Type: Summary
Time: 20-10-2001 23:38:54
Phase: Capturing
Message: 477 rows inserted into table SS2K_SYSCOLUMNS

Type: Information
Time: 20-10-2001 23:38:54
Phase: Capturing
Message: ONRPET Source Model loaded

Type: Information
Time: 20-10-2001 23:38:55
Phase: Capturing
Message: Source Model loaded

Type: Information
Time: 20-10-2001 23:39:09
Phase: Creating
Message: Truncating Oracle Model

Type: Information
Time: 20-10-2001 23:39:13
Phase: Creating
Message: Oracle Model truncated

Type: Information
Time: 20-10-2001 23:39:13
Phase: Creating
Message: Source Model mapped

Type: Information
Time: 20-10-2001 23:39:13
Phase: Creating
Message: Mapping Tablespaces

Type: Information
Time: 20-10-2001 23:39:13
Phase: Creating
Message: mapped tablespace : .sa.ONRPET

Type: Information
Time: 20-10-2001 23:39:13
Phase: Creating
Message: Mapped Tablespaces

Type: Summary
Time: 20-10-2001 23:39:13
Phase: Creating
Message: Tablespaces Mapped: 1, Tablespaces NOT Mapped: 0

Type: Information
Time: 20-10-2001 23:39:13
Phase: Creating
Message: Mapping Users

Type: Information
Time: 20-10-2001 23:39:13
Phase: Creating
Message: mapped user : onrpet.sa.omwb_emulation

Type: Information
Time: 20-10-2001 23:39:13
Phase: Creating
Message: mapped package : onrpet.sa.utilities

Type: Information
Time: 20-10-2001 23:39:13
Phase: Creating
Message: mapped stored procedure : ONRPET.sa.utilities

Type: Information
Time: 20-10-2001 23:39:13
Phase: Creating
Message: mapped stored procedure : ONRPET.sa.SHELL

Type: Information
Time: 20-10-2001 23:39:13
Phase: Creating
Message: mapped package : onrpet.sa.globalPkg

Type: Information
Time: 20-10-2001 23:39:14
Phase: Creating
Message: mapped stored procedure : ONRPET.sa.globalPkg

Type: Information
Time: 20-10-2001 23:39:14
Phase: Creating
Message: mapped stored procedure : ONRPET.sa.DDL_Manager

Type: Information
Time: 20-10-2001 23:39:14
Phase: Creating
Message: Mapped Users

Type: Summary
Time: 20-10-2001 23:39:14
Phase: Creating
Message: Users Mapped: 1, Users NOT Mapped: 0

Type: Information
Time: 20-10-2001 23:39:14
Phase: Creating
Message: Mapping Tables

Type: Debug
Time: 20-10-2001 23:39:14
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:14
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:14
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:14
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:14
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Debug
Time: 20-10-2001 23:39:14
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:14
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:14
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:14
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:14
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Debug
Time: 20-10-2001 23:39:14
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:14
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:14
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:14
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:14
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Debug
Time: 20-10-2001 23:39:14
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:14
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:14
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:14
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:14
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Debug
Time: 20-10-2001 23:39:14
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:14
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:14
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:14
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Debug
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Debug
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Debug
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Debug
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Debug
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Debug
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Debug
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Debug
Time: 20-10-2001 23:39:15
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:15
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:16
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:16
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:16
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Debug
Time: 20-10-2001 23:39:16
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:16
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:16
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:16
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:16
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Debug
Time: 20-10-2001 23:39:16
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:16
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:16
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:16
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:16
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Debug
Time: 20-10-2001 23:39:16
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:16
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:16
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:16
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:16
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Debug
Time: 20-10-2001 23:39:16
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:16
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:16
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:16
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:16
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Debug
Time: 20-10-2001 23:39:16
Phase: Creating
Message: EXCEPTION :OracleModelImpl._insertObjInfo()
java.sql.SQLException: ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Error
Time: 20-10-2001 23:39:16
Phase: Creating
Message: failed to map table : null.null.
[null];oracle.mtg.migration.MigrationSQLException: ORA-01400:
cannot insert NULL into ("SA"."OM_OBJ_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL into
("SA"."OM_OBJ_INFO"."OBJ_OWNER")


Type: Debug
Time: 20-10-2001 23:39:16
Phase: Creating
Message: EXCEPTION :OracleModelImpl._truncateTblColInfo() ORA-
00903: invalid table name


Type: Error
Time: 20-10-2001 23:39:16
Phase: Creating
Message: null : Table. Owner name is NULL. Use the SQL Server
2000 sp_changedbowner/sp_changeobjectowner procedure to assign a
valid login as owner of the table

Type: Error
Time: 20-10-2001 23:39:16
Phase: Creating
Message: EXCEPTION : SQLServer2KSourceModelMap.mapTables():
null.null.[null]; oracle.mtg.migration.MigrationSQLException:
ORA-00903: invalid table name
:ORA-00903: invalid table name


Type: Information
Time: 20-10-2001 23:39:16
Phase: Creating
Message: Mapped Tables

Type: Summary
Time: 20-10-2001 23:39:16
Phase: Creating
Message: Tables Mapped: 0, Tables NOT Mapped: 18

Type: Information
Time: 20-10-2001 23:39:16
Phase: Creating
Message: Mapping Rules

Type: Information
Time: 20-10-2001 23:39:17
Phase: Creating
Message: Mapped Rules

Type: Summary
Time: 20-10-2001 23:39:17
Phase: Creating
Message: Rules Mapped: 0, Rules NOT Mapped: 0

Type: Information
Time: 20-10-2001 23:39:17
Phase: Creating
Message: Mapping Check Constraints

Type: Information
Time: 20-10-2001 23:39:17
Phase: Creating
Message: Mapped Check Constraints

Type: Summary
Time: 20-10-2001 23:39:17
Phase: Creating
Message: Check Constraints Mapped: 0, Check Constraints NOT
Mapped: 0

Type: Information
Time: 20-10-2001 23:39:17
Phase: Creating
Message: Mapping Primary Keys

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 18 2001
Added on Oct 21 2001
#database-and-application-migrations
0 comments
174 views