| ora-3113 with delete.urgent pls help [message #61569] |
Wed, 05 May 2004 14:49  |
Julia
Messages: 30
Registered: December 1999
|
Member |
|
|
This is on 9.2.0.4 and solaris8
try to delete from some of the tables belong to one schema on the server via sqlplus and received this error "ORA-03113: end-of-file on communication channel". This only happens to some tables and works for some other tables. I can't find any major differences between those tables that can cause this problem. alert.log logged ORA-07445: exception encountered: core dump [[kxtotime()+20]] [[SIGSEGV.... and in the trc file, it shows "ORA-07445: exception encountered: core dump [[kxtotime()+20]] [[SIGSEGV]] [[Address not mapped to object]] [[
0x4]] [[]] [[]]..."
There enogh spaces/mem... and this has nothing to do with the size of the table.
Pls help,
Thanks,
Julia.
|
|
|
|
| Re: ora-3113 with delete.urgent pls help [message #61574 is a reply to message #61569] |
Wed, 05 May 2004 20:57  |
Anatol Ciolac
Messages: 113
Registered: December 2003
|
Senior Member |
|
|
ora-3113 usually seem that there has problems with files on OS level.Fact, that this happen only with some tables seem that problems with sone files.Try to execute select segment_name,owner,e.tablespace_name,file_name
from dba_extents e,dba_data_files f
where e.file_id=f.file_id and segment_name=your_table_name
to view in what file are situated your table. Try to view what situation with your files.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
