AW_RENAME Procedure

The AW_RENAME procedure changes the name of an analytic workspace.

Note:

You cannot execute this procedure from within the OLAP Worksheet. You must execute if in a SQL tool such as SQL*Plus.

Syntax

AW_RENAME ( 
          oldname       IN VARCHAR2,
          newname       IN VARCHAR2 );

Parameters

Table B-16 AW_RENAME Procedure Parameters

Parameter	Description
`oldname`	The current name of the analytic workspace. The analytic workspace cannot be attached to any session.
`newname`	The new name of the analytic workspace.

Example

The following command changes the name of the MYAW analytic workspace to DEMO.

SQL>execute dbms_aw.aw_rename('myaw', 'demo');