ORA-01858: while inserting using DB link
insert into dtv.itm_item@Dest_HOSTNAME
select * from dtv.itm_item@Source_HOSTNAME where ORGANIZATION_ID='1' ;
Error report -
ORA-01858: a non-numeric character was found where a numeric was expected
ORA-02063: preceding line from HOSTNAME
I'm trying to insert some data through DB link to a destination DB. I'm getting the ORA-01858: even though the date formats are same.
Source and destination DB is 19C.
Tagged:
0