Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


Databank Options


Databanks may be defined with the LOG, TRANS or NULL 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.

TRANS

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

NULL

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

Note: Operations performed on databanks with the TRANS or NULL 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             IDENTIFIED BY 'devuser';
 SQL> CREATE IDENT JOE AS OS_USER;
 SQL> GRANT TABLE ON DEVELOP TO DEVUSER;
 SQL> GRANT TABLE ON DEVELOP TO JOE;


Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX