Critical Migration issues in Sybase to Oracle using SQL Developer Tool
* How does SQL Developer treat clustered and non-clustered indexes in Sybase while migrating to Oracle?
* For a column in Sybase the default value is given as suser() funtion, but the tool converted it as 'suser' which should be actually uid function which is already there in oracle. How could this be resolved?
* Is there any possibility wherein Sybase user defined datatypes could be mapped to Oracle user defined datatype?
* While moving data using 'Move Data' command in the converted model, we had the failure notification as 'Failed to Disable Constraint-Data Move Failed'. Also while giving 'Generate Data Move Script' it is creating on the control files and two text docs which only contain 'whenever sqlerror continue' (something like this, i dont remembe the exact thing sorry). How could this be resolved? Are w missing out anything? The schema migrated properly. Does data move have also be done immediately or can it be done later?
* Is there any possibilty to move only the table and its associated contraints or indexes during schema migration? Our issue is for a table the associated trigger also got migrated and it gave us some problem as it had dependency on some other table also which is yet to be created. How could this be resolved?