Quick Migrate ORA-00936 missing expression
595434Aug 29 2007 — edited Aug 30 2007I'm using Quick Migrate to migrate a SQL Server 2000 database to Oracle 9.2.0.8. Oracle SQL Developer is installed on a HP workstation xw4100 with an XP operating system. The Quick Migrate was going great until the BUILD section.
The process just halted with the following error:
Error at Command Line: 1,537 Column:55
Error report:
SQL Error:ORA-00936: missing expression
00936. 00000 = "missing expression"
*Cause:
*Action:
Commit
I searched through the BUILD script and found the following:Line:1,537 EffectiveDate TIMESTAMP(6) DEFAULT substring(convert(varchar(20),getdate()),1,11) NOT NULL,
Is this ORA-00936 in the original SQL Server data or the Oracle SQL Developer -Migration_Repos database? The Cause and Action lines are empty?