![]() |
Hello All,
13 Nov 2015
| 5 comments
,
|
![]() |
Can anyone tell me something about locking modifier "LOCKING ROW/TABLE/DATABASE FOR SHARE". Is it same as READ lock?? locking table student.employee for share select * from student.employee;
1) First, we lock a distinct student."pseudo table" for read on a
27 Mar 2015
| 2 comments
,
|
![]() |
Is there any way I can forcefully/manually stop/fail TPT while it is loading (while TPT is in application phase) the staging tables so that the table being loaded is locked and there is no way to access it.
29 Aug 2014
| 1 comment
,
|
![]() |
While using utilities like Multiload, when any job ends abnormally, Teradata still holds locks and we get error 'Table is being mLoaded'.
25 Mar 2014
| 4 comments
,
|