Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2.0.2)

Part Number A95295-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

CreateAWAccessStructures Procedure

This procedure creates a SQL script that will create the relational objects needed for SQL to access objects in the analytic workspace, such as object types and views. It takes a delimited string as input for the mapping information.

Syntax

CreateAWAccessStructures(
   script_directory      VARCHAR2,
   script_filename       VARCHAR2,
   prefix                VARCHAR2,
   aw_name               VARCHAR2,
   mapping_info          VARCHAR2);

Parameters

Table 15-7  CreateAWAccessStructures Procedure Parameters
Parameter Description

script_directory

An existing directory path where script_name will be written.

script_name

The file name that will be given to the generated SQL script. This procedure does not overwrite an existing file, so be sure that a file by the name you specify does not already exist in script_directory.

prefix

A prefix that will be given to the view created by executing the script. This prefix identifies the objects in a schema that relate to the analytic workspace. It can be up to 25 characters long, and must comply with the requirements for a database object name.

aw_name

The name of the analytic workspace where the source objects are stored.

mapping_info

A delimited string that contains mapping information, as described in "Specifying the Source and Target Objects".