3.2.3 Create and Manage R Objects in Oracle Database
With transparency layer functions you can connect to an Oracle Database instance and interact with data tables and views in database schemas.
You can move data to and from the database and create database tables and views. You can also save R objects in the database. The OML4R functions that perform these actions are described in the following topics.
- Using Proxy Objects for Database Data
Using Oracle Machine Learning for R, you can create R proxy objects in your R session to access and manipulate database tables and views. - Create and Delete Database Tables
Use theore.create
function to create a persistent table in an Oracle Database schema. - Create Temporary Database Tables
You can create temporary database tables, and their corresponding proxyore.frame
objects, from local R data.frame objects with theore.push
function. - Create Ordered and Unordered ore.frame Objects
Oracle Machine Learning for R provides the ability to create ordered or unorderedore.frame
objects. - Save and Manage R Objects in the Database
Oracle Machine Learning for R provides datastores that you can use to save OML4R proxy objects, as well as any R object, in an Oracle database.
Parent topic: Use OML4R with an On-Premises Oracle Database