Mark,
Below is info from metalink.
Subject: Ora-01727 Error When Trying To Use Copy Command from 920 to 817
Doc ID: Note:269797.1 Type: PROBLEM
Last Revision Date: 16-JUN-2004 Status: PUBLISHED
The information in this article applies to:
Oracle Server - Enterprise Edition - Version: 8.1.7
This problem can occur on any platform.
Errors
ORA 1727 numeric precision specifier is out of range 1 to 38
COPY
Symptoms
While trying to use the copy command from the 920 to 817 with sqlplus of 8i we get the ORA-1727
error as shown below
C:\Documents and Settings\hasingh>sqlplus harry/harry
SQL*Plus: Release 8.1.7.0.0 - Production on Thu Apr 22 09:35:40 2004
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
With the Partitioning option
JServer Release 8.1.7.4.1 - Production
SQL> copy from ram_xxx/[Email Address Removed] create wh_columns using
select * from wh_columns
Array fetch/bind size is 20. (arraysize is 20)
Will commit when done. (copycommit is 0)
Maximum long size is 1000. (long is 1000)
ERROR:
ORA-01727: numeric precision specifier is out of range (1 to 38)
Cause
:- SQL COPY DOESN'T WORK FROM 9.2.0.3 TO 8.1.7.2 DATABASE WHEN USING
8.1.7.2 CLIENT
Fix
1)The workaorund is to use the SQLPLUS of 920 release to execute the copy command , as the
problem is with 817 SQLPLUS
Connect to 920 sqlplus as shown below
SQL 9.2.0> copy from scott/[Email address protected] to
harry/[Email address protected]
create test using select * from test1 a;
Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)
Table TEST created.
2) apply the patch for the applicable to your platform
References
Bug 3048118 - Sql Copy Doesn'T Work From 9.2.0.3 To 8.1.7.2 Database When Using 8.1.7.2 Client
-----Original Message-----
From: Burris Mark
[mailto:oracledba-ezmlmshield-x29591870.[Email address protected]
Sent: Monday, February 27, 2006 5:40 PM
To: LazyDBA Discussion
Subject: ORA ERROR ORA-01727
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]
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
Oracle LazyDBA home page