Running Oracle schema creation scripts in DB2


Schema enablement for DB2 is as easy as running the Oracle schema creation scripts in DB2. The example on the right pane contains tables and some other database schema described in the data model.


Output


Successful enablement of Oracle schema to DB2 9.7 without making any changes.


Tools for moving schema and data efficiently


Enabling your Oracle database and application to run with DB2 9.7 begins with the deployment of the table schema, followed by the movement of the table data and the deployment of procedural objects.

Table schema objects include table, index and constraint definitions, and procedural objects include PL/SQL packages, procedures, functions, and triggers.

IBM provides a set of tools that simplify and semi-automate the process. The available tools are:-

You can find the detail information about these tools in the Enablement Tools under Enablement Resource section.