• Topic
  • Discussion
  • UdaWikiWeb.WhatDoesCustomCatalogViewsDo(Last) -- Owiki? , 2016-08-19 15:01:31 Edit owiki 2016-08-19 11:01:31

    What does Custom Catalog Views do?

    "Custom Catalog Views" dictates whether custom OpenLink views are used to return metadata for certain ODBC catalog functions; SQLForeignKeys, SQLPrimaryKeys, SQLProcedureColumns, SQLProcedures, and SQLSpecialColumns. These custom views provide more metadata than is normally provided by the standard Oracle data dictionary views.

    To create and use the views, you must first run the odbccat[8|9].sql script. Use the following steps to perform that action:

    1. . Login to the machine that contains the Oracle DBMS.
    2. . su to the oracle user.
    3. . Execute the .profile associated with the oracle user.
    4. . cd into the bin sub-directory of the Oracle installation.
    5. . Run the Oracle server manager command, i.e., svrmgr or sqldba.
    6. . Connect as internal.
    7. . Execute the odbccat.sql script like any other Oracle script file.
    8. . Exit the Oracle server manager.

    The above actions will result in the creation of the following views:

    OPENLINK$SQL_ FOREIGN_ KEYS
    OPENLINK$SQL_ PRIMARY_ KEYS
    OPENLINK$SQL_ SPEC_ COLUMNS
    OPENLINK$SQL_ PROC_ COLUMNS
    OPENLINK$SQL_ PROCEDURES
    OPENLINK$SQL_ PROCS_ NOCOUNT


    Referenced by...