12.2 partition create

[manjini]

Hi erman,

We are trying to convert non-partitioned table to partitioned table with new 12.2 database feature online partitioning.
We already did for other table it really works but one table getting end of communicaiton chanel error after 2 hours.I already checked our limit and its unlimited and also there isnt any restriction at firewall rules.
It might be table has blob columns, am i right?

Here is my command and also table columns describe;

process_id >> varchar2 (36 byte)
response >> blob
request >> blob
time >> date

ALTER TABLE manj.SERVICE_PROCESS_DETAIL MODIFY
  PARTITION BY RANGE (time) INTERVAL(numtodsinterval(1, 'DAY'))
  ( PARTITION P1 VALUES LESS THAN (TO_DATE('16-5-2018', 'DD-MM-YYYY'))) ONLINE;

ORA-03113: end-of-file on communication channel
Process ID: 56367
Session ID: 475 Serial number: 25155
Script will end

[ErmanArslansOracleBlog]

This may be due to a bug or a restriction.

We need to check the trace file for throubleshooting ORA-03113

Check the document named Master Note: Troubleshooting ORA-03113 (Doc ID 1506805.1).
Follow the section named "(C) Client sees ORA-3113 running SQL / PLSQL" + "(E)  Additional Checks / Information" , and try to see what is really going on behind the scenes.