A.2.2.2 Unable able to push an object to Autonomous AI Lakehouse from an Oracle Machine Learning Notebook session using OML4R equivalent of OML4Py
Issue: Used this command to push an object to Autonomous AI Lakehouse.
The Oracle Machine Learning for Python command that works:
oml_iris = oml.create(iris_df, table = 'IRIS_OML4PY')
Error
Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch, : ORA-06598: insufficient INHERIT PRIVILEGES privilege ORA-06512: at "RQSYS.RQ$ADDRSESSIONREFDBOBJECT", line 1 ORA-06512: at line 1 Traceback: 1. ore.push(iris_df, table = "IRIS_OML4R") 2. ore.push(iris_df, table = "IRIS_OML4R") 3. .ore.addObjects(env, tabName, "table", "purge") 4. .ore.QueryEnv$addRefObjects(objName, objType, objParm) 5. .ore.dbGetQuery(stmt, data = refdbobjs) 6. .ore.QueryEnv$dbGetQuery(qry, noframe = noframe, return = return, . ...) 7. ROracle::dbGetQuery(.ore.con(), qry, ...) 8. ROracle::dbGetQuery(.ore.con(), qry, ...) 9. .local(conn, statement, ...) 10. .oci.GetQuery(conn, statement, data = data, prefetch = prefetch, . bulk_read = bulk_read, bulk_write = bulk_write)
Resolution: Run this command instead:
oml.create != ore.push
Note:
Oracle Machine Learning for Python has its ownpush
function. Moreover, the
push
function does not take a table argument.
Parent topic: OML4R