10.2 Datastore and Script Repository Views supporting Embedded R Execution

OML4R includes a number of database views that contain information about datastores and about the scripts and user-defined functions in the datastores. You can use these views with the embedded R execution APIs to work with the datastores and their contents.

View Description
ALL_RQ_DATASTORES

Describes the datastores available to the current user.

ALL_RQ_SCRIPTS

Describes the scripts in the OML4R script repository that are available to the current user.

RQUSER_DATASTORECONTENTS

Contains information about the contents of Oracle Machine Learning for R datastores.

RQUSER_DATASTORELIST

Contains information about Oracle Machine Learning for R datastores.

USER_RQ_DATASTORE_PRIVS Describes the datastores and the users to whom the current user has granted read privilege access.
USER_RQ_DATASTORES Describes datastores created by the current user.
USER_RQ_SCRIPT_PRIVS Describes the scripts in the OML4R script repository to which the current user has granted read access and the users to whom access has been granted.
USER_RQ_SCRIPTS Describes the scripts in the OML4R script repository that are owned by the current user.