getting errors while migrate to oracle ...
I am using Oracle 9.0.1 running on win 2000 server and I have migrated my sql 2000 server to my oracle databse,I found some errors which i unable to resolve with my own.I am pasting few of them plz give a serious look to it and I am fairly new to database migration .these are ...
Migrating sa.SPT_VALUESCLUST Failed to create index:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Migrating sa.DATATYPEINFOCLUST Failed to create index:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Migrating sa.SPT_MONITOR Created Table :
table contains date column. Milliseconds not migrated
Migrating sa.SYSJOBSCHEDULES Failed to create default for Table :
ORA-02262: ORA-4044 occurs while type-checking column default value
expression
Migrating sa.SPT_FALLBACK_USG Created Table :
table contains date column. Milliseconds not migrated
Migrating sa.SYSDBMAINTPLAN_HISTORY Failed to create default for Table :
ORA-01465: invalid hex number
Migrating sa.SYSDBMAINTPLAN_HISTORY Failed to create default for Table :
ORA-01465: invalid hex number
Warning occured on line 20:
Rollback in trigger(EMPLOYEE_INSUPD)
Error occured on line 3:
oracle.mtg.sqlserver2k.parser.ParseException: Parse error at line 3, column 121.
Encountered
How to counter these errors as it very Imp to me to overcome from these
your help would be highly Appriciated.
with very warm regards : Alok Kumar