This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Jan 25, 2013 10:44 AM by 986238 Go to original post RSS
  • 15. Re: R installation R not Found error
    986238 Newbie
    Currently Being Moderated
    My bad... I now installed the rest of the zip files based on your previous instructions.

    I am now able to run the R script. However, it did not list any user tables.
    The ore.sync() produced warning messages.
    One of the warning message I displayed indicated:
    "testusr"."testtbl1" contains unsupported data types

    Therefore, it looks like I am able to connect to the Oracle database using R.
    However, R is not able to list the tables due to "unsupported data types" issue?
    It looks like I have some reading to do about the R Environment.
  • 16. Re: R installation R not Found error
    Denis Mukhin Journeyer
    Currently Being Moderated
    The number of supported data types in ORE 1.1 is limited. It was lifted in ORE 1.3. However, we don't yet have an ORE 1.3 Server for Windows (it should be coming out fairly soon). What you can do is list the tables that you want synced instead of getting all. This way you can bypass tables with unsupported types. The most common type that is not supported in ORE 1.1 (but supported in ORE 1.3) is TIMESTAMP (with all the varieties). So if you want to sync only tables <tt>FOO</tt> and <tt>BAR</tt> you can do
    ore.sync(table=c("FOO","BAR"))
    Denis
  • 17. Re: R installation R not Found error
    986238 Newbie
    Currently Being Moderated
    Excellent. I am also reading up on section "Example: Load Data" of the user's Guide that may be of value.

    I appreciate your help in resolving my install/setup issue.
    I could not have done this without your help.

    THANKS !!!
1 2 Previous Next

Legend

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