SQL*Plus (MOSC)

MOSC Banner

SQLDeveloper Sybase to Oracle Migration error.

edited Dec 13, 2013 9:20AM in SQL*Plus (MOSC) 2 commentsAnswered
I'm getting following errror when tried to migrate the schema from Sybase to Oracle.. Any thoughts??

Running 3.0.04 SQL Developer.

oracle.dbtools.migration.command_line.CMDLineError: Problem executing SQL : CREA
TE OR REPLACE TRIGGER "GENCONNKEYTRIG"
                                        BEFORE INSERT ON stage_serverdetail
                                        FOR EACH ROW
                                        BEGIN
                                          IF :new.project_id is null THEN
                                             :new.project_id := MD_META.get_next_id;
                                          END IF;
                                          IF :new.svrid is null THEN
                                             :new.svrid := MD_META.get_next_id;

                                          END IF;
                                        END GenConnKeyTrig;
        at oracle.dbtools.migration.capture.CaptureCmd.executeSQL(CaptureCmd.jav
a:385)
        at oracle.dbtools.migration.capture.CaptureCmd.createStagingTables(Captu
reCmd.java:365)
        at oracle.dbtools.migration.capture.CaptureCmd.onlineCapture(CaptureCmd.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center