***
This article is being delivered in Draft form and may contain
errors. Please use the MetaLink "Feedback" button to advise
Oracle of any issues related to this article.
***
Purpose
To inform Migration specialists how to migrate DB2 packed decimal data type.
Scope & Application
The audience for this document is Oracle customers, partners and migration specialists.
Migrate DB2 Packed Decimal Data Type

To efficiently migrate DB2 packed decimal data type to an Oracle Database, follow these steps:
- unload the DB2 data in a flat file
- transfer the file with FTP without changing the format from EBCDIC to ASCII
- load the data with SQL*Loader and use the right characterset,

e.g.: LOAD DATA CHARACTERSET WE8EBCDIC500

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy