1. Scripting Reference for Oracle Essbase
  2. MaxL
  3. MaxL Statements
  4. MaxL Statement Reference
  5. Query Archive_File

Query Archive_File

The MaxL query archive_file statement helps you retrieve information about the Essbase database backup archive file. The archive file is created using alter database DBS-NAME begin | end archive.

Syntax


Description of query_archive_file.gif follows
Description of the illustration query_archive_file.gif

FILE-NAME

Keywords

You can query archive file information in the following ways using MaxL query archive_file. To issue this statement, the database must be started first, and you need at least Database Access permission for the application.

query archive_file … get overview

Retrieve the application name, database name, and time of archive.

query archive_file … list disk volume

Retrieve a list of disk volume names.

Example

query archive_file 'samplebasic.arc' get overview;

Retrieves overview information about the samplebasic.arc backup archive file. 

query archive_file 'samplebasic.arc' list disk volume;

Retrieves disk volume information about the samplebasic.arc backup archive file.