This discussion is archived
1 Reply Latest reply: Nov 8, 2012 4:31 AM by Denis Mukhin RSS

"Contains unsupported data types" error

973199 Newbie
Currently Being Moderated
I am trying to install and use Oracle Enterprise R. My installation appears to be successful, but I am having problems with ore.sync(). Here is the code that I am using:
user = "martin"
password = "infopower"
sid = "INFODB"
host = "192.168.6.51"
ore.connect(user, sid, host, password)
ore.ls()
character(0)
ore.sync(user)
Warning messages:
1: "MARTIN"."MARTIN_WT" contains unsupported data types
2: "MARTIN"."JON_TEST" contains unsupported data types
3: "MARTIN"."JON_TEST2" contains unsupported data types
4: "MARTIN"."DIM_MATERIAL" contains unsupported data types
5: "MARTIN"."DIM_CUSTOMER" contains unsupported data types

It looks like I have connected successfully to the database, but the ore.sync() command doesn't seem to work. Please help.
  • 1. Re: "Contains unsupported data types" error
    Denis Mukhin Journeyer
    Currently Being Moderated
    ore.sync() does not yet support columns of all types. The following types are not yet supported: LONG, LONG RAW, BLOB, BFILE, TIMESTAMP and INTERVAL families, and UDTs. To bypass tables with these columns it is possible to use ore.sync() with an explicit list of tables specification as in ore.sync(table = c("FOO", "BAR")).

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points