You can use the ore.create function to create a persistent table in an Oracle Database schema. Creating the table automatically creates an ore.frame proxy object for the table in the R environment that represents your database schema. The proxy ore.frame object has the same name as the table. You can delete the persistent table in an Oracle Database schema with the ore.drop function.
Caution:
Only use the ore.drop function to delete a database table and its associated ore.frame proxy object. Never use it to remove an ore.frame object that is not associated with a permanent database table. To remove an ore.frame object for a temporary database table, use the ore.rm function.
Example 2-17 Using ore.create and ore.drop to Create and Drop Tables
This example creates tables in the database and drops some of them.
# Create the AIRQUALITY table from the data.frame for the airquality data set. ore.create(airquality, table = "AIRQUALITY") # Create data.frame objects. df1 <- data.frame(x1 = 1:5, y1 = letters[1:5]) df2 <- data.frame(x2 = 5:1, y2 = letters[11:15]) # Create the DF1 and DF2 tables from the data.frame objects. ore.create(df1, "DF1") ore.create(df2, "DF2") # Create the CARS93 table from the data.frame for the Cars93 data set. ore.create(Cars93, table = "CARS93") # List the Oracle R Enterprise proxy objects. ore.ls() # Drop the CARS93 object. ore.drop(table = "CARS93") # List the Oracle R Enterprise proxy objects again. ore.ls()Listing for Example 2-17
R> # Create the AIRQUALITY table from the data.frame for the airquality data set. R> ore.create(airquality, table = "AIRQUALITY") R> # Create data.frame objects. R> df1 <- data.frame(x1 = 1:5, y1 = letters[1:5]) R> df2 <- data.frame(x2 = 5:1, y2 = letters[11:15]) R> # Create the DF1_TABLE and DF2_TABLE tables from the data.frame objects. R> ore.create(df1, "DF1") R> ore.create(df2, "DF2") R> # Create the CARS93 table from the data.frame for the Cars93 data set. R> ore.create(Cars93, table = "CARS93") R> # List the Oracle R Enterprise proxy objects. R> ore.ls() [1] "AIRQUALITY" "CARS93" "DF1" "DF2_" R> # Drop the CARS93 object. R> ore.drop(table = "CARS93") R> # List the Oracle R Enterprise proxy objects again. R> ore.ls() [1] "AIRQUALITY" "DF1_" "DF2"