Determine Analytic Workspace Creation Date

[ola...@gmail.com]

This script will show you the creation date for Analytic Workspaces in
your instance.

select owner||'.'||substr(object_name,4) as aw_name, created
from dba_objects where object_name like 'AW$%'
and object_name != 'AW$'
group by owner, object_name, created
order by owner, aw_name;

AW_NAME CREATED
-------------------------- ---------
ADAM.PRODUCT 15-MAY-04
SCOTT.MYAW 03-MAR-04
SYS.AWCREATE 02-APR-04
SYS.AWCREATE10G 02-APR-04
SYS.AWMD 02-APR-04
SYS.AWXML 02-APR-04
SYS.EXPRESS 02-APR-04