Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-03113: end-of-file on communication channel

491563Jun 14 2009 — edited Jun 15 2009

Hi All,
when i use the following delete statement in a partitioned table I am getting the following error.

SQL : Delete FROM ACCT_FACT WHERE timeID = 1689

Error : ORA-03113: end-of-file on communication channel

the table is parttioned based on timeid and when I try to truncate the table it is going through successfully.

Can anyone please enlighten me on why I am getting this error when I try to delete from fact table

Note : I am not gettin this error for all partitions and all parttions are compressed

Thanks,
Silambu

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2009

Added on Jun 14 2009

#general-database-discussions

11 comments

1,423 views