2.2 Create and Manage R Objects in Oracle Database

With transparency layer functions you can connect to an Oracle Database instance and interact with data structures in a database schema.

You can move data to and from the database and create database tables. You can also save R objects in the database. The OML4R functions that perform these actions are described in the following topics.

• Create R Objects for In-Database Data
  Using Oracle Machine Learning for R, you can create R proxy objects in your R session for database-resident data.
• Create Ordered and Unordered ore.frame Objects
  Oracle Machine Learning for R provides the ability to create ordered or unordered ore.frame objects.
• Move Data to and from the Database
  You can create a temporary database table, and its corresponding proxy ore.frame object, from a local R object with the ore.push function.
• Create and Delete Database Tables
  Use the ore.create function to create a persistent table in an Oracle Database schema.
• 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.