Toad World® Forums

Toad Data Point Table Locking

Is there any information about how or if TDP import/export wizard uses table locking? We're trying to determine if any of the processes we've set up need to be altered as we've had a few conflicts and may need to allow dirty reads.

If on a relational database--which this sounds like--you may need to get with the DBA and make sure that the isolation level for such tables are set appropriately... allowing for others to see dirty reads usually means that the isolation level on the database side needs to have the lowest setting.

Alternatively, you can always make a copy of the table data just before any export/import, if the data is not too large.