Databanks may be defined with the LOG, TRANS or NULL options which determine transaction handling and logging behavior, as follows:
All operations on the databank are performed under transaction control. All transactions are logged.
All operations on the databank are performed under transaction control. No transactions are logged.
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 Backup and Restore.
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
The following is an example where 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