How can I export data from tables in oracle apex cloud free account ?
I need to generate insert statements and insert the data to MAXAPEX paid account
I searched for that but I cannot find the way , also I don’t know how to export the schema tables and data using
EXPDP utility
from oracle apex free account
So I generated DDL script from SQL WORKSHOP for tables but I need the data also
How can I generate insert statements script ?
>Solution :
I don’t think you can. expdp is an operating system command prompt utility, and you don’t have that.
One option (though, works for a single table at a time) is to use Data Workshop‘s Data unload. Here’s a walkthrough (follow the wizard between steps 3 and 4):
You’d then import (load) such a comma-separated file into the target table (database).