|Create table as select generates ORA-03113 [message #286274]
||Fri, 07 December 2007 01:31
Registered: March 2006
I am running long-time (~2,5h) warehouse data load-up scripts, and they crash always with the same error:
CREATE TABLE DIMENSIONS.TMP01_T
ERROR at line 1:
ORA-03113: end-of-file on communication channel
The table DIMENSIONS.TMP01_T is created using CREATE TABLE AS SELECT.... statement.
The table DIMENSIONS.TMP01_T actually gets created in the database (with ~3million records). The next statement is
CREATE INDEX index_name1 ON DIMENSIONS.TMP01_T ( KOMISO_GAVEJAS_KEY ) TABLESPACE &INDEX_SPACE;
It does not get executed. I assume Oracle crash somewhere in the middle of these two.
The warehouse data load-up scripts are run using sqlplus utility on the server PC.
The error is received on productional database where Redo logs are running. On test database where no redo logs are running it was not possible to repeat the error.
I post so many various details because if i try searching info on ORA-03113, i find smth like:
Copied from: http://www.dba-oracle.com/m_ora_03113_end_of_file_on_communications_channel.htm
For example, ORA-3113 could be signaled for any of these scenarios:
- Server machine crashed
- Your server process was killed at O/S level
- Network problems
- Oracle internal errors / aborts on the server
- Client incorrectly handling multiple connections
- etc.. etc.. etc.. - a lot of possible causes !!
How do I know which scenario is my case?
So far I have stiked out :
- Server machine crashed (not possible, databse continues to operate);
- Network problems (not possible, scripts were executed on server PC);
- Client incorrectly handling multiple connections (not sure about that, but scripts use one connection only).
Here is also the core dump log:
Date/Time: Wed Dec 5 22:35:47 WET 2007
Sequence Number: 11639
Resource Name: SYSPROC
SOFTWARE PROGRAM ABNORMALLY TERMINATED
USER GENERATED SIGNAL
CORRECT THEN RETRY
RERUN THE APPLICATION PROGRAM
IF PROBLEM PERSISTS THEN DO THE FOLLOWING
CONTACT APPROPRIATE SERVICE REPRESENTATIVE
USER'S PROCESS ID:
FILE SYSTEM SERIAL NUMBER
CORE FILE NAME
STACK EXECUTION DISABLED
If you have any ideas what is happening, help please. I am totally confused by this error.