Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't read “uniqueidentifier” and “long” datatype in sql server

620489Aug 4 2009 — edited Dec 31 2009

Dear all!
While trying to mapping table from table source (in SQL server 2005) to table destination (in Oracle 10.2.0.4) I found data type “uniqueidentifier” and “long” is not support for Warehouse Builder 10.2 although I connect successful to source and destination database.
Does this mean I can't use “uniqueidentifier” and “long fields in OWB.
I have 2 questions:

*1) What can I do to read “uniqueidentifier” and “long” datatype into Oracle database?*
*2) Could you tell me datatype in Oracle use as “uniqueidentifier” and “long” SQL server data type?*

Please guys help me out.

Thanks in advance.
KhanhND

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 28 2010

Added on Aug 4 2009

#data-warehousing, #warehouse-builder

4 comments

3,707 views