SQL Developer

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!

Quick Migrate ORA-00936 missing expression

595434Aug 29 2007 — edited Aug 30 2007

I'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?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 27 2007

Added on Aug 29 2007

#sql-developer

1 comment

812 views