Datatype changed after IMPORT of schema

Asked Dec 22 '17 at 07:07

Active Dec 22 '17 at 08:56

Viewed 219 times

please advice on EXPDP and IMPDP utilities, Oracle 12c DB administration.

We exported schema TEST (DB 11.2.0.4) using EXPDB utility and imported dump file to new DB (DB 12.2.0.1.0) using IMPDP utility.

After import we checked one of tables - stock. it has column SAP_MM - Datatype changed to FLOAT(126). but in source DB it has NUMBER(38).

May be someone came across such issue - datatype conversion. What can be the reason?

edited Dec 22 '17 at 08:56

asked Dec 22 '17 at 07:07

Bulat Makhmutov

1

Did you run the import with `TABLE_EXISTS_ACTION=REPLACE`? – Dec 22 '17 at 08:55
No, i did not. Can it be the source of problem? – Bulat Makhmutov Dec 22 '17 at 09:41
If the table already existed with the wrong definition, then the import would not change it – Dec 22 '17 at 09:51
thanks for reply, I will check. – Bulat Makhmutov Dec 23 '17 at 10:36

0 Answers0