Search

Top 60 Oracle Blogs

Recent comments

Oracle12c

12c upuserxt.lst, upobjxt.lst & Oracle Maintained objects/users

By Franck Pachot

.
Mike Dietrich has blogged recently about upuserxt.lst and upobjxt.lst and how to query them with external table. The first time I’ve seen those ‘.lst’ files, the default extension for sqlplus spool files, I wondered whether they were provided in ?/rdbms/admin on purpose, or if they were just some leftovers from some tests Oracle did before packaging the Oracle Home. Finally, I realized that they were there on purpose and that those ‘.lst’ are important files when upgrading to 12c.