OraFAQ Forum: SQL & PL/SQL » ORA-01727: numeric precision specifier is out of range (1 to 38)

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01727: numeric precision specifier is out of range (1 to 38)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01727: numeric precision specifier is out of range (1 to 38) [message #27410]

Tue, 30 September 2003 23:53

Sunil
Messages: 132
Registered: September 1999

Senior Member

Hi,
I am trying to use COPY command to copy table from one schema to another(both are on different databases). But on doing so I am getting the following error
ORA-01727: numeric precision specifier is out of range (1 to 38)

On looking at the table that i ant to copy i see that the numerix flds are 38(NUMBER (38) and a few with data type FLOAT(126) in length .I have only read rights on the table and cannot modify table, is there any way i could still copy the table as it is, it works fine for other tables.
Thanks

Report message to a moderator

Previous Topic:	How to delete duplicate rows from a table?
Next Topic:	how to make ER Diagram for the tables given with the business rules

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 13:53:31 CDT 2024