For a use case where you develop an application using ADF Fusion stack. When you need to plan backup and restore scenario for your application, you must consider both application code as well as database related artifacts.
This post explains how you can recover the DB objects (Tables, Columns, Primary & Foreign keys)
Steps to resurrect DB objects from your Entity objects:
In the Model project, create Business Components Diagram (Under ADF Business Components)
Drag all the Associations and Entities on the diagram. This should create a Entity hierarchy in the diagram
Now Right click on an empty space in diagram and select ‘Generate Business Objects’ > ‘Database Objects for Diagram’
This will replace any existing tables and remove data. So use this only when you need to recreate tables from scratch.
All site content is the property of Oracle Corp. Redistribution not allowed without written permission