This content has been marked as final. Show 2 replies
One simple option in SQLDev 18.3 is this (depends on your needs):
- Select tables in tree of source server, click with right mouse button on one of selected tables and select Export.... You will get Export Wizard dialog with 3 steps.
- Check both options (Export DDL and Export Data) and for Format select Insert. You can try to play with many options above. Click Finish at the last step.
- You will get new saved SQL script file and also new SQL worksheet with generated script.
- Copy or open this script on target server and run it.
You can also drag and drop from MySQL to Oracle connection, or use Copy to Oracle right click option