'How to export application oracle apex with all data in all tables using supporting objects?
I want to export/import an oracle apex application between two different workspaces. i have already tried to create supporting objects then export the application and import it to the other workspace but i found all tables were empty. how can i export the application with all data in tables?
Solution 1:[1]
Starting oracle APEX 21.2 there is a feature called "data packager" that allows you to export tables with their data. Google this for some examples it probably meets your needs.
Solution 2:[2]
In order to do that, you would need liquibase and sqlcl installed.
With this, you can run liquibase command :
- lb genobject -type apex -applicationid
- lb genobject -type schema -name
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Koen Lostrie |
| Solution 2 | Shashi |