PURGELINKEDOBJECTS

Deletes objects linked to the active database for a given user name or modification date.

Syntax

PURGELINKEDOBJECTS userName modDate
ParameterDescription

userName

The name of a user. If userName is specified, Essbase deletes all objects last modified by the given user.

modDate

A modification date. If modDate is specified, Essbase deletes all objects modified on or before the given date.

Notes

This command deletes linked objects based on criteria you specify. A list of the objects matching your criteria appears as they are being deleted. If you specify both a user name and modification date, objects matching both criteria are deleted. If you specify no user name or date, all linked objects in the database are deleted.

You must select a database before using PURGELINKEDOBJECTS. You must also have design privilege for the database to delete any objects.

For more information on linked objects, see the Oracle Essbase Database Administrator's Guide.

Example

To delete all objects last modified by user Diana on or before July 7, 2002:

PURGELINKEDOBJECTS "Diana" "07/07/2002";