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!

Supporting objects: How to include tables and data?

partlycloudyAug 12 2006 — edited Sep 9 2006
Trying to use the new Application deployment features in 2.2 to create a packaged application that includes all supporting database objects (tables, views, packages, triggers, etc).

From what I can tell, I need to go to the Scripts tab in http://i7.tinypic.com/24fiqv5.jpg and attach scripts to do all the object creation.

That is fine for the DDL part, but how would I go about including the data in all the tables involved? Some of the tables are pretty large.

Can I do a command line "exp" of all the tables/data attach that binary file to the package? But is the Apex import process able to import the file i.e. run the "imp" utility?

Can someone shed some light on this?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2006
Added on Aug 12 2006
14 comments
1,030 views