create table in_doc3 (
  in_id    number(10)
 ,doc_date timestamp default systimestamp not null
 ,constraint pk_in_doc3 primary key (in_id)
) partition by range(doc_date) (
  partition p_2017 values less than (to_date('01.01.2018','dd.mm.yyyy'))
 ,partition p_default values less than (maxvalue)
);
create table out_doc3 (
  out_id   number
 ,in_id    number(10) not null
 ,constraint pk_out_doc3 primary key (out_id)
 ,constraint fk_out_doc3$in_id foreign key (in_id) references in_doc3 (in_id)
) partition by reference (fk_out_doc3$in_id);
create index ik_out_doc3$in_id on out_doc3 (in_id) local;

ALTER TABLE in_doc3 MODIFY in_id NUMBER(19,0);
ALTER TABLE out_doc3 MODIFY in_id NUMBER(19,0);

ERROR at line 1:
ORA-14060: data type or length of a table partitioning column may not be
changed


begin
  dbms_redefinition.can_redef_table(uname => user, tname => 'IN_DOC3');
end;
/

ERROR at line 1:
ORA-23549: table "YOU"."IN_DOC3" involved in reference partitioning
ORA-06512: at "SYS.DBMS_REDEFINITION", line 283
ORA-06512: at "SYS.DBMS_REDEFINITION", line 5808
ORA-06512: at line 2

alter table OUT_DOC3 drop constraint FK_OUT_DOC3$IN_ID;
ERROR at line 1:
ORA-14650: operation not supported for reference-partitioned tables

drop table out_doc3;
drop table in_doc3;