Skip to Main Content

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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 27 2007
Added on Aug 29 2007
1 comment
813 views