My Oracle Support Banner

Migration via SDCLI Generate Creates NullPointerException; SDCLI Qm Creates An Error; Sdcli Datamove Doesn't Work (Doc ID 2423672.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle SQL Developer - Version 17.4 and later
Information in this document applies to any platform.


You are attempting to automate a migration process using SDCLI (SQL Developer Command Line Interface).

When running SDCLI migration -
actions=generate -model=latest
it results in a:
java.lang.NullPointerException and no tables are created.

When running -
then tables and procedures are created, but an error is encountered:
ORA-00904 OBJECT_ID : invalid identifier in the command DELETE FROM MD_TARGET_ALL_OBJECTS WHERE....

You then follow up with the datamove command. It says it is successful, but no data is moved.

You then follow that up by performing the data move via the SQL Developer GUI. This is successful, but doesn't help with automating the process.

What is the correct way to setup a migration automation via SDCLI command?



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.