OpenEdge DB-to-Oracle utility

The OpenEdge DataServer for Oracle supports the OpenEdge DB-to-Oracle utility that allows you to migrate an OpenEdge database to an Oracle database. While the DataServer typically makes an Oracle database conform to an OpenEdge database, this utility provides compatibility in the opposite direction. It copies an existing OpenEdge database schema into a target Oracle database. The utility performs the following tasks:

Creates objects in the target Oracle database

Creates the schema holder and schema image

Optionally populates the Oracle database by dumping and loading the data from the OpenEdge database

The Oracle database you create with this utility is a basis for an application database. Before deploying your new Oracle database, you might want to make manual adjustments to take advantage of additional Oracle features that are not supported by the migration utility, such as clustering and multiple tablespaces.

The OpenEdge-to-Oracle utility has the following requirements:

A local OpenEdge database

Oracle permissions, as identified in the following table

Table 60. Oracle permissions
Permission	Object
CREATE SESSION	Database
CREATE TABLE	Database
CREATE SEQUENCE	Database
SELECT	System objects: sys.argument$ sys.cclol$ sys.cdef$ sys.col$ sys.com$ sys.con$ sys.dual sys.icol$ sys.ind$ sys.link$ sys.obj$ sys.procedure$ sys.seq$ sys.syn$ sys.tab$ sys.ts$ sys.user$ sys.view$
CREATE SEQUENCE	Database
Enough quota	Default table space

In this section:

Preparing a database for the utility

Oracle size limitations

Naming conventions

Oracle tablespaces for tables and indexes

Running the OpenEdge DB-to-Oracle utility

Handling character length during database migration