Skip Headers
Oracle® OLAP DML Reference
11g Release 1 (11.1)

B28126-03
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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 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');