Post reply

Transferring UNIQUEIDENTIFIER to oracle

  • July 13, 2011 at 3:14 am

    #241482

    Hi All,

    I have a table with ID Column which is a uniqueidentifier data type

    And I would like to tranfer this column to ORACLE RAW(16) data type via LINKED Server.

    How will i achive this?

    MY Query is :

    INSERT INTO [LINKED_SERVER]..[SCHEMA].

    (

    ID_ORACLE )

    SELECT top 1

    CONVERT(VARCHAR(36),ID) FROM TABLE

    ID_ORACLE is RAW(16)

    ID is Uniqueidentifier?

    Kind Regards,

  • July 13, 2011 at 4:40 am

    #1352044

    I know nothing about Oracle. That being said, does Oracle not have database names that you're skipping over it in your INSERT clause?

    Why are you copying a single column table over to Oracle in the first place?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply