I blogged about upuserxt.lst
lists Oracle Supplied User Schemas and Roles a while ago. But I thought it’s time to refresh this blog post a bit and adjust it to be more useful. upuserxt.lst
displays the Oracle Supplied User Schemas and Roles since Oracle Database 12.1.0.1.
upuserxt.lst
lists Oracle Supplied User Schemas and Roles
You can access upuserxt.lst
simply with an external table.
- Create a directory object:
CREATE OR REPLACE DIRECTORY ext_tab_data AS '/u01/app/oracle/product/12.2.0.1/rdbms/admin/';
- Define the external table to query it:
CREATE TABLE oracle_supplied_usr_ext ( schema_role VARCHAR2(128) ) ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY ext_tab_data ACCESS PARAMETERS (