Databank Options

---

Databanks may be defined with the LOG, TRANSACTION, WORK, or READ ONLY options which determine transaction handling and logging behavior, as follows:

• LOG

  All operations on the databank are performed under transaction control. All transactions are logged.

• TRANSACTION

  All operations on the databank are performed under transaction control. No transactions are logged.

• WORK

  All operations on the databank are performed without transaction control (even if they are requested within a transaction), and are not logged.

• READ ONLY

  Only read only transactions are allowed. No transactions are logged.

• TEMPORARY

  This option is SQLDB specific.

Note: Operations performed on databanks with the TRANSACTION or WORK option cannot be restored in the event of system failure, see Backing-up and Restoring Data.

If a databank is dropped from the database, the tables stored in the databank are also dropped and the physical databank file is deleted from disk.

Creating Idents and a Databank - an Example

In the following example, a databank and two users (idents) are created. The idents are then given the authority to create tables within the databank:

 SQL> CREATE DATABANK DEVELOP OF 1000 PAGES
             IN 'dev.dbf' WITH LOG OPTION;
 SQL> CREATE IDENT DEVUSER AS USER USING 'devuser';
 SQL> CREATE IDENT JOE AS OS_USER;
 SQL> GRANT TABLE ON DEVELOP TO DEVUSER;
 SQL> GRANT TABLE ON DEVELOP TO JOE;

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se