This discussion is archived
5 Replies Latest reply: Jul 13, 2012 8:00 AM by mkirtley-Oracle RSS

SQL server to Oracle

860250 Newbie
Currently Being Moderated
Hi,

I am trying to convert TEXT Type of sqlserver to Oracle. In oracle createad a field of type CLOB.

When I try to insert the same data from sqlserver Text type field to Oracle for CLOB type. It's not working as length of string is 31538.

Please suugest a datatype in Oracle which can hold SQL server Text datafield data.

Thanks in advance.
  • 1. Re: SQL server to Oracle
    kgronau Guru
    Currently Being Moderated
    Which tool did you use to move/migrate the content from SQL Server to Oracle?
  • 2. Re: SQL server to Oracle
    860250 Newbie
    Currently Being Moderated
    Hi,

    To create my table I used SQL developer to convert create table script from SQL server to Oracle.

    Note: I have not migrated data from SQL Server to Oracle.

    Edited by: 857247 on Jul 13, 2012 4:21 PM
  • 3. Re: SQL server to Oracle
    mkirtley-Oracle Expert
    Currently Being Moderated
    Hi,
    You said you get an error trying to insert data. What is the command or method you are using to move the data ?

    Regards,
    Mike

    Edited by: mkirtley on Jul 13, 2012 3:03 PM
  • 4. Re: SQL server to Oracle
    860250 Newbie
    Currently Being Moderated
    Hi,

    I am just trying to insert data manually using insert statement by copying data from sql server database.

    Is there any way where I can migrate data by establishing connection between oracle & SQL server.

    I am new to SQL server.

    Thanks.
  • 5. Re: SQL server to Oracle
    mkirtley-Oracle Expert
    Currently Being Moderated
    Hi,
    If it is a one off move of the data then you can use the SQL*developer migration workbench. Have a look here -

    http://www.oracle.com/technetwork/database/migration/index-084442.html

    You can use this to migrate individual tables if you want to do this.


    If you want to use the gateway then have a look at this note in My Oracle Support -

    Copying Data Between an Oracle Database and Non-Oracle Foreign Data Stores or Databases Using Gateways (Doc ID 171790.1)

    If you are using the copy command and have errors then give us the folloiwng details -

    1. The SQL*Server table create statement
    2. The Oracle table create statement
    3. the syntax you are using for the insert or copy statement
    4. The errors you receive

    Regards,
    Mike

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points