RODM_open_dbms_connection: Open a connection to an Oracle Database

In RODM: R interface to Oracle Data Mining

Description

This function opens a connection to an Oracle Database.

Usage

RODM_open_dbms_connection(
   dsn,  
   uid = "",
   pwd = "")

Arguments

dsn	ODBC Data Source Name.
uid	Database user id.
pwd	Password for the database user.

Details

This functions opens an ODBC channel to an Oracle database by calling the RODBC function: odbcConnect(dsn=dsn, uid=uid, pwd=pwd, case="oracle").

It validates that the database is Oracle version 11, that Oracle Data Mining is installed, and that the connecting user has appropriate privileges for mining in the database.

The necessary privileges for connecting and mining are as follows: CREATE SESSION, CREATE TABLE, CREATE VIEW, and CREATE MINING MODEL. The connecting user will also need quota in a tablespace.

The first time RODM_open_dbms_connection is invoked for a given database user, this function will also create a temporary table to hold settings that are used to build ODM models (table name RODM_SETTINGS_TABLE).

Value

An Oracle database ODBC channel.

Author(s)

Pablo Tamayo [e-mail]

Ari Mozes [e-mail]

References

Oracle Data Mining Administrator's Guide 11g Release 1 (11.1) http://download.oracle.com/docs/cd/B28359_01/datamine.111/b28130/toc.htm

See Also

RODM_close_dbms_connection

Examples

# Given a database user rodm, establish a connection to the orcl11g
# database.
# The database user would need privileges as described above, and could
# have been created in a fashion similar to:
# grant create session, create table, create view, create mining model, 
#       unlimited tablespace to rodm identified by rodm;
## Not run: 
DB <- RODM_open_dbms_connection(dsn="orcl11g", uid="rodm", pwd="rodm")

# Close the connection to the database.
RODM_close_dbms_connection(DB)

## End(Not run)

RODM documentation built on May 2, 2019, 7:03 a.m.