ora-00054????

[matoretta]

hi do anybody know where is mistake ???
the procedure has problem with truncate table

ora - 00054: resource busy and acquire with NOWAIT specified
ora - 06512 at "POVAPSYS.HMAN_P_REFRESH", line 6
ora - 06512 at "POVAPSYS.POVAPSYS", line 6
ora - 06512 at line 1


this is my procedure....

AS
BEGIN
execute immediate 'TRUNCATE TABLE hman_t_max';
INSERT INTO hman_t_max SELECT * FROM hman_v_max;
COMMIT;

END;

[davey23uk]

you cant truncate it if someone is using it

[matoretta]

hi yes it could be that someone else use it but how to solve this problem i read that i can use delete instead of truncate, or is there some possibility lock table before truncate it and then unlock it??

[Scorby]

Delete is a lot slower than truncate and wouldn't work any better if someone is holding update locks on the table. The only real option is to identify who is locking the table and kill their session.