Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Hi,
We have both informix and oracle database in our organization. The
informix Universal Server 9.x database contains a table with "text"
and "html" data type fields. We are trying to create a similar table
in Oracle 8i database.
1. I created a flat delimited file using Informix's unload utility.
2. Then I created an oracle table with CLOB field to accomodate
informix's table field with "text" datatype.
3. Then I used Oracle's SQL*loader utility to load this table on Oracle.
I am geeting Error message in the log file saying that data doesnot fit
in to oracle's column with "CLOB" datatype. Then changed the oracle's
table definition using different oracle datatypes to accomodate "Text"
datatype. I am still getting the same error? Is there a way to solve
this problem? I have been trying to solve this problem for over two
weeks. Your help will be appreciated>
Vijay
Sent via Deja.com http://www.deja.com/
Before you buy.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.