Try OpenEdge Now
skip to main content
DataServer for Oracle
The DataServer Tutorial : OpenEdge DB-to-Oracle utility
 

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
* 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