Oracle Supplied Objects Listing in upobjxt.lst ... ... Oracle Supplied Users Listing in upuserxt.lst
By Mike Dietrich-Oracle on Jan 21, 2015
Maybe not important to many people but as I didn't find much about it via a search I'd thought I post something about the new upobjxt.lst and upuserxt.lst files. Since Oracle Database 188.8.131.52 we deliver these files in ?/rdbms/admin .
All Oracle supplied objects are kept in an external table format.
The file's name is: upobjxt.lst
If you'd like to access it you may do the following:
- Create a directory object:
CREATE OR REPLACE DIRECTORY ext_tab_data AS '/u01/app/oracle/product/184.108.40.206/rdbms/admin/';
- Define the external table to query it:
CREATE TABLE oracle_supplied_ext (
ORGANIZATION EXTERNAL (
DEFAULT DIRECTORY ext_tab_data
ACCESS PARAMETERS (
RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY ','
MISSING FIELD VALUES ARE NULL
REJECT LIMIT UNLIMITED;
- Now you can query from the table oracle_supplied_ext.
select count(*), object_type
group by object_type
order by 2;
- Would you like to match object types to object codes? Try this one ...:
select count(o.type#), o.type#,d.object_type
from dba_objects d, obj$ o
group by o.type#,d.object_type
order by 2;
Object mapping can be found also in the definition of OBJ$ in the dcore.bsq file
All Oracle supplied users are kept in an external table format in another file named: upuserxt.lst