Skip to Main Content

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!

APEX - export application with data

Steve.1234555-OracleAug 1 2012 — edited Aug 6 2012
Hello,

I reviewed a similar thread (10493174 but still need guidance.

I am trying to export my application and include all tables and data/rows in tables. I've created a DDL (SQL Workshop > Utilities > Generate DDL), however when I review the script created (SQL Workshop > SQL Scripts) it only shows the table definition, and not the data in the table. I believe I've created the script correctly (I checked "all" for Object Type and for Tables/View/Sequences etc).

I tried exporting the app just in case it did extract all data. First I downloaded the DDL script, and then uploaded to MyApplication > Supporting Objects > Installation Scripts. Then I went to MyApplication > Export / Import > Export > set all export preferences to "yes" > Export Application... The resulting sql file does not contain table data.


How do I accomplish this?

Steve

Edited by: Steve on Aug 1, 2012 2:11 PM

Edited by: Steve on Aug 1, 2012 2:12 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2012
Added on Aug 1 2012
9 comments
2,864 views