grant rqrole to

• grant execute on rqsys.rqGroupEvalImpl for each user.
• Create all the synonyms listed in rquser.sql for each user.

From a client

# Load ORE packages and dependencies
# DBI, ROracle, OREbase, MASS, OREstats,
# OREgraphics, OREeda, ORExml, ORE
library(ORE)
 
 
# Change the following connection settings:
user     <- "scott"
password <- "tiger"
sid      <- "mysid"
host     <- "myhost"
port     <- 1521
all      <- TRUE
 
cat("Connecting to ORE\n")
cat("    User:", user, "\n")
cat("    SID: ", sid, "\n")
cat("    Host:", host, "\n")
ore.connect(user, sid, host, password, port, all)

that you can add in a startup scriptOracle R Enterprise includes the following R functions that enable transparent access to Oracle Database tables and views:

• ore.attach(USER, SID, host, password) establishes a database connection using the schema or user name, the database SID, machine hostname, and password, and creates an environment that maps database table names to R objects (ore.frame) from the schema referenced in the database connection. At this time, views are not mapped. If you use the all parameter of ore.connect when you attach to a database, ore.attach is executed automatically.
• ore.sync() synchronizes with your schema (account) in the Oracle Database. ore.connect can perform this command. If you use the all parameter of ore.connect when you attach to a database, ore.sync is executed automatically.
• ore.detach(“SCHEMA_NAME”) detaches from the schema.
• ore.ls() lists all objects in the schema you are currently connected to.

Objects created by Oracle R Enterprise are identified with the ore prefix. Pick any object returned by ore.ls() and type either class(OBJECTNAME) or class(OBJECTNAMECOLUMN_NAME).For example,

R> class(NARROW)
[1] "ore.frame"
attr(,"package")
[1] "OREbase"

The prefix ore is applied to the class names. This indicates that the object is an Oracle R Enterprise created object that holds metadata (instead of contents) of the corresponding object in Oracle Database.Scripts have been added as demos to the ORE package.To access a complete listing of them type

demo(package = "ORE")

To run one of these scripts, specify the name of the demo in a demo function call. For example, to run aggregate.R, type

demo("aggregate", package = "ORE")

table_apply.R   Execute R code on all rows of a table passed in at once
aggregate.R     Demonstrates aggregations. See also summary.R
analysis.R      Demonstrates basic analysis and data processing operations
basic.R         Demonstrates basic connectivity to database
binning.R       Demonstrates binning in R
columnfns.R     Demonstrates use of column functions
corr.R          Correlation matrix (Pearson's, Spearman/Kendalls)
crosstab.R      Frequency cross-tabulations. Also see freq.R
derived.R       Handling derived columns
distributions.R Distribution, Density, and Quantile Functions
doEval.R        Demonstrates support for database-enabled parallel simulations
freqanalysis.R  Frequency cross-tabulations. Also see crosstab.R
graphics.R      Demonstrates visual analysis (boxplot, histogram)
group_apply.R   Execute R code for different sets of rows, one set per group
hypothesis.R    Hypothesis Testing Functions(binomial, chi square, T test, etc.)
matrix.R        Matrix operations
nulls.R         Demonstrates handling of nulls in SQL vs. NAs in R
push_pull.R     Demonstrates collaborative processing between database and client
rank.R          Ranking of observations (ranking, handling ties, etc.)
reg.R           Multivariate Regression
row_apply.R     Execute R code on each row
sql_like.R      Demonstrates how R commands map to SQL operations
stepwise.R      Stepwise Multivariate Regression
summary.R       Demonstrates summary functionality

• Install Client