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 OCTOBER 16, 2019

Applies to:

Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle SQL Developer - Version 17.4 and later
Information in this document applies to any platform.

Goal

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 -
actions=qm
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?

 

Solution

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

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


In this Document
Goal
Solution


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