Progress
DataServer
for ORACLE Guide


Using the DataServer Utility to Create a Schema Holder

Once you have started ORACLE, the DataServer processes, and created and connected to a local empty Progress database, you can create the schema holder. This example uses Windows; the character-based interfaces have the same sequence of screens. Follow these steps to create the schema holder:

  1. From the Data Administration main menu, select DataServer ORACLE Utilities Create DataServer Schema. The following dialog box appears.
  2. If you are using character-based Progress, select DataServer ORACLE Utilities Create DataServer Schema from the Data Dictionary main menu.

  3. Type a logical database name in the Logical Database Name field. You use the logical database name to connect to your ORACLE database. You also use it to refer to the database in your programming applications. For more information on database names, see the Progress Programming Handbook.
  4. If you are building a schema holder for a distributed ORACLE database, the logical name that you choose must be unique across the distributed database.

    NOTE: If you place the schema image from a second non-Progress database into a schema holder, you must give the second schema image a different logical database name from the first schema. The schema holder has one physical name, but each schema image it contains must have a different logical name.

  5. In the Code-Page field, type the name of the code page for the schema image. The name must be the Progress name for the code page that the ORACLE Call Interface (OCI) uses.
  6. If your ORACLE environment uses a code page that Progress does not support, you must supply a conversion table that translates between the Progress client code page and the code page that ORACLE uses.

    See the "Code Pages" section in "Programming Considerations," for more information on how the DataServer handles code pages and code-page conversion tables. For a complete discussion of code pages, see the Progress Internationalization Guide.

  7. In the Oracle Version field, type the version number of ORACLE you are using. Possible values are 7 (the default) or 8.
  8. Type the required connection parameters in the Connection Parameters field.
  9. At a minimum, you need the User ID (-U) and Password (-P) parameters. Remote connections also require networking parameters. See the "Connecting a Schema Holder at Startup" section in "Connecting the DataServer," for a description of the required and optional connection parameters. This is how you identify the ORACLE user in a SQL*Net or Net 8 connection:

    -U userid@service-name -P password 
    

  10. Choose OK. The utility prompts you to verify the ORACLE user ID and password.
  11. If you did not specify the User ID (-U) and Password (-P) parameters in the previous dialog box, type an ORACLE user ID and password combination that has the privileges required for creating a schema holder. Table 3–7 lists these permissions.
  12. Choose OK. The following dialog box appears:
  13. Preselect the objects that the schema holder should contain. You can select these objects by object name, object type, or owner. By default, the wildcard symbol (*) appears and specifies that the utility selects all objects. Typically, you should not include system-owned objects.
  14. Choose OK.
  15. If your ORACLE database is part of a distributed database, a dialog box listing the linked databases that make up the distributed database appears.

  16. Select the linked databases whose objects you want to include in the schema holder, then choose OK. The Pre-Selection dialog box appears so that you can select objects by name, type, and owner.
  17. Choose OK. The following dialog box appears:
  18. Select the objects that you want to include in the schema holder.
  19. If object names repeat across a distributed database, the DataServer qualifies each name by adding -n. For example, if you database has two INVOICE tables, the schema holder will list them as INVOICE and INVOICE-1.

  20. Choose OK. The DataServer reads information about the database objects and loads the data definitions into the schema holder. The time this process takes depends on the size and number of the ORACLE objects.

For each table, the DataServer selects an index or the native ROWID to support the Progress ROWID. If an ORACLE object (such as some views) does not support the ROWID function, the DataServer issues the warning, “Please check warnings and messages in the file ds_upd.e.” The ds_upd.e file lists the objects that do not support ROWID.

You can change the DataServer’s selection by using the Progress Data Dictionary. For example, you can choose to use an alternate integer index or the native ROWID. See the "Defining the ROWID" section in "The DataServer Tutorial," for instructions. See the "ROWID Function" section in "Programming Considerations," for more information on ROWID.

If the DataServer encounters ORACLE errors while creating or maintaining schema information or loading data, it displays the ORACLE message and message number on screen. See your ORACLE documentation for complete descriptions of the error messages.

The DataServer makes an additional connection to the schema holder when it creates, updates, or verifies a schema image. If you are connecting to multiple databases or schema images, make sure that you set the Number of Databases (-h) parameter to a value that accommodates the number of databases and schema images plus one.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095