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;
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.