Convert CLOB to LONG

[EM1107]

Good day everyone!

I am new to Oracle and I was tasked to migrate a SQL server database to Oracle.

The problem I have is not getting the tables to Oracle but a restriction with the application that connect to the Oracle database. It does not work with CLOB it only recognize LONG. The DTS application that is use in SQL server does not copy text format in any other format than CLOB.

How can I convert a CLOB field to LONG after getting the table in my Oracle database?

 

[SantaMufasa]

Your situation, EM, is problematic...Oracle is de-supporting LONG datatype in favour of CLOB. If you have an application that does not support CLOB, then the solution should be for your application provider to release a version that fully supports CLOB.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.