Home » SQL & PL/SQL » SQL & PL/SQL » data in sample table can't be inserted into db- error :ORA-00054
icon14.gif  data in sample table can't be inserted into db- error :ORA-00054 [message #220184] Mon, 19 February 2007 06:30 Go to next message
Messages: 1
Registered: February 2007
Location: Chennai
Junior Member
hi ,
i am using table named SAMPLAUDITLOGEENTRY table.
No alarm that SAMPLAUDITLOGEENTRY can't be inserted into db.
Risk that the disk becomes full since no one knows about the problem.
There was some problem with the partition in the external database. This for some reason caused the audittrail logs to not be inserted into db, all other logs worked ok.
No alarm was raised about the problem, so the disk usage

we are not able to delete,insert,update any record on the table and they could
not drop/truncate audittraillogenrty table due to "ORA-00054: resource busy and
acquire with NOWAIT specified" error.

Re: data in sample table can't be inserted into db- error :ORA-00054 [message #220275 is a reply to message #220184] Tue, 20 February 2007 00:14 Go to previous message
Messages: 19
Registered: April 2005
Junior Member
Perhaps you have an uncommited transaction.

select process from v$locked_object where object_id = (
    select object_id from all_objects 
    where object_name = 'SAMPLAUDITLOGEENTRY') ;

Take a look at the corresponding process, and make a call whether to terminate it.

You may also want to look at lock level in v$lock.
Previous Topic: help for slecting right options
Next Topic: execution of procedure in trigger
Goto Forum:

Current Time: Mon Oct 24 13:21:21 CDT 2016

Total time taken to generate the page: 0.09533 seconds