Enterprise Edition Home |
Express Edition Home |
Previous Page | Next Page Locking > Locks with the SELECT Statement >
The database server does not place page or row locks on
a nonlogging table when you use the table within a transaction.
Use one of the following methods to prevent concurrency problems
when other users are modifying a nonlogging table:
- Lock the table in exclusive mode for the whole transaction.
- Use Repeatable Read isolation level for the whole transaction.
Important:
Nonlogging raw tables are intended for fast loading of
data. It is recommended that you change the table to STANDARD before
you use it in a transaction or modify the data within it.
Enterprise Edition Home |
Express Edition Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]