5 Replies Latest reply: Jul 13, 2012 10:00 AM by Mkirtley-Oracle RSS

    SQL server to Oracle

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