Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The CONVERT
procedure converts an analytic workspace in 9i storage format to to 10g storage format. Note that you cannot execute this procedure from within the OLAP Worksheet; you must execute if in a SQL tool such as SQL*Plus.
Note:
Issuing thedbms_aw.convert
procedure is only one small step in upgrading Oracle 9i analytic workspaces to Oracle 10g workspaces. For the complete procedure for upgrading Oracle 9i analytic workspaces, see Oracle OLAP Application Developer's Guide, 10g Release 2 (10.2).See:
For information on converting an analytic workspace to Oracle 11g storage format, see Oracle OLAP User's Guide.CONVERT ( original_aw IN VARCHAR2);
CONVERT ( original_aw IN VARCHAR2, converted_aw IN VARCHAR2, tablespace IN NUMBER DEFAULT);
Table B-19 CONVERT Procedure Parameters
Parameter | Description |
---|---|
|
The analytic workspace you want to convert. |
|
The converted analytic workspace. |
|
The name of a tablespace in which the converted workspace is stored. If this parameter is omitted, then the analytic workspace is created in the user's default tablespace. |
This example performs the conversion in a single step, using the analytic workspace as both the source and the target of the conversion.
EXECUTE dbms_aw.convert('global');
The next example performs the conversion in several steps. The converted workspace must have the same name as the original workspace, because the fully qualified names of objects in the workspace include the workspace name.
EXECUTE dbms_aw.rename('global', 'global_temp'); EXECUTE dbms_aw.convert('global_temp', 'global'); EXECUTE dbms_aw.delete('global_temp');