This discussion is archived
4 Replies Latest reply: Sep 19, 2012 7:53 AM by 84959 RSS

ORA-00902: invalid datatype

957720 Newbie
Currently Being Moderated
Hi,

I'm performing Sybase 15 to Oracle 11g migration with SQL Developer 3.1.07.

I found the ORA-00902: invalid datatype error while the migration stopped.

How can i find which datatype exactly is invalid?

Thanks,
Sathiesh
  • 1. Re: ORA-00902: invalid datatype
    mkirtley-Oracle Expert
    Currently Being Moderated
    Sathiesh,
    At what point in the migration do you get the error and are you making an online or offline migration ?
    Can you detail the steps youhave made until you get the error ?

    If you are making an online migration then when you get to the 'Target Database' step change the mode to 'Offline' to generate the scripts and click finish.

    If you get the erro during the 'Move Data' step then change the mode to offline and continue from there.
    THis gives more control over what is happening and should enable you to see what is causing the problem.

    Regards,
    Mike
  • 2. Re: ORA-00902: invalid datatype
    957720 Newbie
    Currently Being Moderated
    Mike,

    I perform an offline migration. I get this error after i initiate an offline migration choosing online source and offline for target ie I pointed a filder for the script generation. As the migration faied no scripts and log files was generated in the folder.

    Thanks,
    Sathiesh
  • 3. Re: ORA-00902: invalid datatype
    mkirtley-Oracle Expert
    Currently Being Moderated
    Sathiesh,
    Okay - thanks for the update. Let me check and I'll get back to you.

    Regards,
    Mike
  • 4. Re: ORA-00902: invalid datatype
    84959 Explorer
    Currently Being Moderated
    Hello

    Can you try the migration again with the latest version of SQLDeveloper (3.2.0.9)?. It will generate a log file in the project directory. So we will have an idea as to where the failure occurs. Secondly you can also try the migration in phases i.e.

    1. Just perform a capture first. To do so, on the capture phase screen (online/offline source selection), click on the 'Go to Summary Page' option at the bottom of the screen.
    2. Complete the capture process.

    Repeat the same steps again for just convert and then generate also.

    Regards

    Prakash

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points