Search code examples
oracle-databaseoracle-apex

How can I export schema data from oracle apex cloud free account?


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

  • You could also use the "data packager" feature that was introduced in apex 21.2. here is a demo video.