ORA-3113 / ORA-00060 When Converting Large Non-Partitioned Table To A Partitioned Table
(Doc ID 2997898.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.19.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : 19.19.0.0.0 version, RDBMS
When attempting to alter table
the following error is observed by the foreground process.
ERROR
-----------------------
ORA-03113: end-of-file on communication channel
Process ID: 3505134
Session ID: 364 Serial number: 38489
STEPS
-----------------------
ALTER TABLE TEST_TABLE
PARTITION BY RANGE (COL1_LASTUPDATE)
INTERVAL (NUMTOYMINTERVAL (1,'MONTH'))
( partition part_old values less than (to_date('01-JAN-2016','DD-MON-YYYY') ));
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |