To create an Oracle schema you can use Oracle's own 'Database Designer' product. To use this, you will need your DP4 database set up as an ODBC data source, and to have installed the DP4 ODBC Drivers.
Use the Reverse Engineer Wizard to retrieve the information from the DP4 database as an ODBC database. To produce a schema more suited for use with the DP4 Oracle Interface you need to have the following entry in your DP4 Configuration File:
[odbc]
oracle=1
When you have produced the data diagram, you simply use the Generation Wizard to produce the schema file.
If the DP4 database has any field, table, or index names that are Oracle reserved words, the schema produced by the Database Designer will contain these illegal names.
If you know that some of these names exist, edit the schema file by hand. Make a note of the names that need changing and the changes you make, so that this information can be included later in a translation table for the DP4 Oracle Interface.
If you do not know whether your DP4 database uses Oracle reserved words, we recommend that you post the schema file into Oracle, watching for errors. These will indicate that you are trying to create a schema object using an Oracle reserved word. If you do find any reserved words, as before, rename them to allowed words, making a note of changed names for inclusion in a translation table later.
You can use the DP4 program RESWORDS to add a list of reserved words to a database to prevent them being used as table or field names. We can supply files ready for posting with RESWORDS that contain the official list of SQL reserved words (there may be some more for Oracle).