Number (7.2) or Integer

[CatPlus]

I copy a table from one schema to another using directions at

http://www.oracleutilities.com/SQLPLus/copy.html

However, the fields in originating table is Number (7,2) whereas the destination table brings the field as integar value which rounds off numbers, for example, 9.2 is brought over as 9 and 9.51 brings over 10

What parameter should I use to specify field/column properties? I am using Oracle version 9

Please help

 

[SantaMufasa]

Cat,

I just tried to simulate your situation:

SQL> desc s_emp
 Name                    Null?    Type
 ----------------------- -------- -------------
 ID                      NOT NULL NUMBER(7)
 LAST_NAME               NOT NULL VARCHAR2(25)
 FIRST_NAME                       VARCHAR2(25)
 USERID                           VARCHAR2(8)
 START_DATE                       DATE
 COMMENTS                         VARCHAR2(255)
 MANAGER_ID                       NUMBER(7)
 TITLE                            VARCHAR2(25)
 DEPT_ID                          NUMBER(7)
 SALARY                           NUMBER(11,2)
 COMMISSION_PCT                   NUMBER(4,2)

copy from test/<pw>@dhunt to test/<pw>@dhunt create s_emp2 using select * from s_emp;

   25 rows selected from test@dhunt.
   25 rows inserted into S_EMP2.
   25 rows committed into S_EMP2 at test@dhunt.

SQL> desc s_emp2
 Name                    Null?    Type
 ----------------------- -------- -------------
 ID                      NOT NULL NUMBER(7)
 LAST_NAME               NOT NULL VARCHAR2(25)
 FIRST_NAME                       VARCHAR2(25)
 USERID                           VARCHAR2(8)
 START_DATE                       DATE
 COMMENTS                         VARCHAR2(255)
 MANAGER_ID                       NUMBER(7)
 TITLE                            VARCHAR2(25)
 DEPT_ID                          NUMBER(7)
 SALARY                           NUMBER(11,2)
 COMMISSION_PCT                   NUMBER(4,2)

Notice that the column definition for "SALARY" was (11,2) in the original table and is the same in the resulting table.

To help isolate your problem, can you please post the COPY code that you used?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[CatPlus]

Thanks Mufasa!

DESC revealed the column was INTEGER. Changed it to NUMBER and it works!

Appreciate your help

Happy Thanksgiving
Mickey