Oracle9i OLAP User's Guide Release 2 (9.2) Part Number A95295-01 |
|
CWM2_OLAP_AW_ACCESS , 8 of 9
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. As input, it takes a text file that maps the workspace objects to columns of the views.
CreateAWAccessStructures_FR( script_directory VARCHAR2, script_name VARCHAR2, prefix VARCHAR2, aw_name VARCHAR2, infile_directory VARCHAR2 infile_name VARCHAR2);
Parameter | Description |
---|---|
|
An existing directory path where |
|
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 |
|
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. |
|
The name of the analytic workspace where the source objects are stored. |
|
The directory path where the |
|
The name of the input file that contains mapping information, as described in Example , "Specifying the Source and Target Objects". |
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|