Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to export app & its tables and data?

DannyS-OracleAug 1 2016 — edited Aug 1 2016

Hi Apex gurus, experts, masters, and professors,

I am trying to export one application from my workspace to my co-worker's workspace, but so far we can only export & import the application (pages) - without the tables and data. It seems there is no straightforward way to export tables from the Object Browser. I already tried the Generate DDL script from menu SQL Workshop > SQL Script, chose the tables, but got this error when my co-worker tried to install the script to his own workspace:

image001.png

I also looked into this thread: Export APEX application, DDL and data, which suggest SQL Developer to do the table and data export. But the problem is I am using Oracle Cloud Apex as a Service. I don't know how to make remote connection to it.

Is there an easier solution for this? Any help will be appreciated!

P.S. I am using Apex v5.0.3

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 29 2016
Added on Aug 1 2016
#apex, #apex-discussions, #database, #export, #import, #oracle, #script, #table
7 comments
3,739 views