Text2Oracle
motify type of column
HanWang
2008-03-10 19:37:53.0
hi,
when I execute export,error:

Prepare to export :DelayedDataHK-SL-0227.zip.DELAYEDDATAHK-SL --> PF99.DELAYEDDATAHK-SL
java.sql.SQLExceptionORA-01754: a table may contain only one column of type LONG
java.sql.SQLException: ORA-01754: a table may contain only one column of type LONG

but I can not motify type of column,How is it so?

Thinks

motify type of column
HanWang
2008-03-10 19:42:00.0
hi,
when I execute export,error:

Prepare to export :DelayedDataHK-SL-0227.zip.DELAYEDDATAHK-SL --> PF99.DELAYEDDATAHK-SL
java.sql.SQLExceptionORA-01754: a table may contain only one column of type LONG
java.sql.SQLException: ORA-01754: a table may contain only one column of type LONG

but I can not motify type of column,How is it so?

Thinks

Re:Re:motify type of column
HXTT Support
2008-03-11 06:08:24.0
Doesn't the DELAYEDDATAHK-SL table exist in oracle database and need created? It seemed that you assigned or auto map two LONG type column accord you DelayedDataHK-SL-0227.zip.DELAYEDDATAHK-SL table when create the table in oracle database.
You can see here to know how to change the target table column type.


Google