Skip to main content
Hi there,

 

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,

 

 

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

Reply