Using alter database in MaxL

Issue a separate alter database statement for each database setting you want to change. For example, the following MaxL script logs on to Essbase, changes three database settings, and logs off:

login admin identified by secretword;
alter database sample.basic enable committed_mode;
alter database sample.basic set lock_timeout immediate;
alter database sample.basic disable create_blocks;
logout;

Note:

Terminate each MaxL statement with a semicolon when issuing them using the MaxL Shell; however, if MaxL statements are embedded in Perl scripts, do not use the semicolon statement terminator.

You can use MaxL to write batch scripts that automate database setting changes. See the MaxL Language Reference, located in the Oracle Essbase Technical Reference.