5 Replies Latest reply on Jul 13, 2012 3:00 PM by Mkirtley-Oracle

    SQL server to Oracle


      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
          Which tool did you use to move/migrate the content from SQL Server to Oracle?
          • 2. Re: SQL server to Oracle

            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
              You said you get an error trying to insert data. What is the command or method you are using to move the data ?


              Edited by: mkirtley on Jul 13, 2012 3:03 PM
              • 4. Re: SQL server to Oracle

                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.

                • 5. Re: SQL server to Oracle
                  If it is a one off move of the data then you can use the SQL*developer migration workbench. Have a look here -


                  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

                  1 person found this helpful