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

OLADM2999 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 commands detach the DEMO analytic workspace and change its name to SALES_DEMO.

EXECUTE dbms_aw.aw_detach('demo');
EXECUTE dbms_aw.aw_rename('demo', 'sales_demo');