I am trying to migrate Oracle dump datas into gdb. The reader reads every column except raw format type and giving a warning "skipping column". Has anybody have any idea?
Hi there,
Page 1 / 1
Hi,
that is because a Raw column can contain just about anything. You need to specify the contents in some way, e.g. if it contains a UUID you can convert it to a string containing a hexadecimal representation of the contents using the Oracle function RawToHex().
One way to read such an Oracle table would be by using a SQLCreator rather than the regular Oracle reader, using a query such as:
select
OBJECTID,
rawtohex(MY_UUID) as MY_UUID,
NAME
from
MYTABLE
For the above example, you would expose the attributes OBJECTID, MY_UUD and NAME in the SQLCreator.
David