end of communication channel

[holdingbe]

hi all,

some of the time, while executing of full outer join scripts , i got the ora-03113 end of communication channel.

pls help me..

[debasisdas]

Cause: The connection between Client and Server process was broken.
Action: There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.

[debasisdas]

You need to recover this datafile or remove

startup mount
alter tablespace offlline
alter database rename datfile -- or add datafile
online TS
recover database automatic