Retal Omar
Retal Omar

Reputation: 39

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?

Upvotes: 1

Views: 2351

Answers (2)

Koen Lostrie
Koen Lostrie

Reputation: 18705

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.

Upvotes: 1

Shashi
Shashi

Reputation: 100

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

Upvotes: 0

Related Questions