upobjxt.lst

I blogged about upobjxt.lst lists Oracle Supplied Objects a while ago. But I thought it’s time to refresh this blog post a bit and adjust it to be more useful. upobjxt.lst displays the Oracle Supplied Objects since Oracle Database 12.1.0.1.

upobjxt.lst lists Oracle Supplied Objects and Users

Create an External Table

You can access upobjxt.lst simply with an external table.

1. Create a directory object:

   CREATE OR REPLACE DIRECTORY ext_tab_data AS '/u01/app/oracle/product/19/rdbms/admin/';

2. Define the external table to query it:

   CREATE TABLE oracle_supplied_obj_ext (
   owner       VARCHAR2(31),
   name        VARCHAR2(127),
   placeholder VARCHAR2(20),
   object_type NUMBER
   )
   ORGANIZATION EXTERNAL (
   TYPE ORACLE_LOADER
   DEFAULT DIRECTORY ext_tab_data
   ACCESS