Hi,
I have a dmp exported from Oracle 9i (9.2.0.1.0) and I'm using it on 10g (10.2.0.1.0). Everything works fine except this type of code:
select *
from table_name
where column_name = 3;
column_name's type is NUMBER(1,0). I only have this problem when column type is NUMBER(1,0). I changed the type from NUMBER(1,0) to NUMBER, but I still get this error when using this column...
When running this code I get in less than 5 seconds
ORA-17410: No more data to read from socket and nothing else works anymore until I disconnect and connect again to the DB. When I run this code on Oracle 9i it works. I only have this problem on Oracle 10g.
Can you help me?
Thx.