I am trying to copy a table from the MIG schema in the dev3 database on
one box in Oracle 10g to the MIG schema in the tst2 database on another
box in Oracle 8.1.7. What is causing this error? Does it have
something to do with the client versions. I can't go from 10g to 8i but
I could go the other way around on a copy statement? Do I have to us a
10 client for 8i?



copy from mig/[Email Address Removed] create rrps_mig_dev using -

select * from rrps_mig;

update rrps_mig r

set ddl_dt = trunc(SYSDATE),

script_name = (select distinct r2.script_name

from rrps_mig_dev r2

where r.object_name = r2.object_name

and r.object_type = r2.object_type

and r2.add_dt =(select max(r3.add_dt)

from rrps_mig_dev r3



ERROR:

ORA-01727: numeric precision specifier is out of range (1 to 38)



Mark Burris

DBA

DOR/ITD

Phone (317) 232-0206

[Email address protected]






Oracle LazyDBA home page