3 Replies Latest reply: Mar 1, 2012 2:06 PM by 202127 RSS

    sql srver datetime to oracle by sql developer

    202127
      Using the tool Sql Developer 3.1.07, try to migration an sql server 2008 database to oracle 11gR2. The tool failed at a few places. One point:

      sql server table:

      create table Table1 (
      ...
      [modificationDatetime] [datetime] NOT NULL,
      ...
      )

      The tool generated Oracle script for the same table:

      create table Table1 (
      ....
      modificationDatetime DATE DEFAULT SYS_EXTRACT_UTC NOT NULL,
      ...
      )

      The script actually does not work in oracle with the error:
      SQL Error: ORA-00984: column not allowed here
      00984. 00000 - "column not allowed here"

      Simplely replacing 'SYS_EXTRACT_UTC' with 'sysdate' works.

      Wondering if this is a bug of the tool.


      Thanks,

      Fan

      Edited by: FanZeng on Feb 23, 2012 11:42 AM