Oracle Database Discussions

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!

Unique Identifiers to RAW(16)

810389Nov 3 2010 — edited Nov 8 2010

Hi,
We are migrating our SQL Server 2008 database to Oracle 11g.
In our tables we have the primary key column as UniqueIdentifier. we mapped the data type mapping for UniqueIdentifier to be raw(16).

We were able to successfully migrate the schema in the Oracle database.
But when trying to load the data it gives us an error: “invalid hex number”

Any ideas to get around this problem?

Thanks,
Amar

Edited by: user2027823 on Nov 3, 2010 11:32 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 6 2010

Added on Nov 3 2010

#database-and-application-migrations, #migration, #server, #sql

10 comments

1,896 views