| how to remove DDL lock from a table [message #373062] |
Sun, 25 March 2001 05:12  |
Narendra
Messages: 10
Registered: March 2001
|
Junior Member |
|
|
i work on oracle under unix. i use to face a problem frequently that is,
suppose i am updating a table and in the mean time my
process is killed, now again if i try any DDL statement (like alter table or drop/create index etc.) on the table, i receive a message like-
timeout occurred while waiting for DDL lock.
how to remove this lock without shutting down database.
if you have any suggestions kindly suggest me.
thank you.
|
|
|
|
| Re: how to remove DDL lock from a table [message #373065 is a reply to message #373062] |
Mon, 26 March 2001 00:31  |
Thirumalai and Prakash
Messages: 23
Registered: March 2001
|
Junior Member |
|
|
Hi Mr.Narendra,
Try this,
Kill the particular oracle session using the orakill utility. Using the following guidelines,
Usage: orakill sid thread
where sid = the Oracle instance to target
thread = the thread id of the thread to kill
The thread id should be retrieved from the spid column of a query such as:
select spid, osuser, s.program from
v$process p, v$session s where p.addr=s.paddr;
Hope it helps !
Regards
S.Thirumalai
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
