Creating OLAP Metadata Catalogs Manually

If you choose to create the OLAP Metadata Catalog manually, you must run SQL scripts by using the same utility program that you normally use to create tables.

The scripts that you use to create the tables for a non-Unicode OLAP Metadata Catalog are named:

oc_create_database_name.sql

The scripts that you use to create the tables for a Unicode OLAP Metadata Catalog are named:

oc_create_database_name_unicode.sql

These scripts are listed in Table 1, SQL Scripts for Creating an OLAP Metadata Catalog, along with the utility programs with which they have been tested.

Note:

strongly recommends that you use the automatic installation process to create the OLAP Metadata Catalog (see Creating or Upgrading OLAP Metadata Catalogs Automatically).

  To create tables for the OLAP Metadata Catalog database manually:

  1. Start the utility program.

  2. Connect to the database that you created for the OLAP Metadata Catalog.

  3. Open the appropriate SQL script file in the ocscript directory.

  4. Run the SQL script to build the tables.

    On Microsoft SQL Server, you receive a message that you did not create data or rows. This message is normal because you created only tables and columns.

  5. Verify that you have created the OLAP Metadata Catalog tables.

    For example, type a command such as:

    SELECT * FROM JOIN_HINTS

    or, start the applicable RDBMS utility program and verify that the OLAP Metadata Catalog has the new tables.

  6. Close the utility program.