Databanks may be defined with the LOG, TRANSACTION, WORK, or READ ONLY options which determine transaction handling and logging behavior, as follows:
- READ ONLY
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