Hi All,
When iam trying to Import Metadata from Oracle 10g database, the values for the table fields are imported as multiples of 3. For example say for a field Field_nbr1 has a datatype Varchar2(10), , when I import metadata using Orchestrate schema then the imported value is Varchar2(30), we had turned off UNICODE option while importing.
Please let me know how to solve this issue.Thanks in advance
Regards
Cherry
Meta Data
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Doesn't matter. You have NLS enabled. Oracle reports "three bytes per character" sizing. Go with it - it works.
If you want to you can more closely qualify the data type when creating the table, using one of VARCHAR2(n BYTE) or VARCHAR2(n CHAR).
If you want to you can more closely qualify the data type when creating the table, using one of VARCHAR2(n BYTE) or VARCHAR2(n CHAR).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.