Differences

upuserxt.lst lists Oracle Supplied User Schemas and Roles

Posted on March 15, 2018 by Differences 4

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.

Photo by Faustin Tuyambaze on Unsplash

 

upuserxt.lst lists Oracle Supplied User Schemas and Roles

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

  1. Create a directory object: 
    CREATE OR REPLACE DIRECTORY ext_tab_data AS '/u01/app/oracle/product/12.2.0.1/rdbms/admin/';
  2. 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 (
… Continue reading...

upobjxt.lst lists Oracle Supplied Objects

Posted on March 14, 2018 by Differences 0

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

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
… Continue reading...

Package Differences between Oracle 11.2.0.4 and 12.1.0.2?

Posted on June 23, 2015 by Differences Oracle Database 11g Oracle Database 12c 2

The question sounds pretty trivial:

Which packages did exist in Oracle 11.2.0.4 but don’t exist in Oracle 12.1.0.2 anymore?

And going a bit deeper into the topic,

Which procedures and functions calls of SYS packages have been changed since then?

A colleague of mine (thanks to Thomas Kempkens from ACS Support for writing up a fancy procedure – all credits go to him) had to dig this out for a customer,

See the result.
These packages don’t exist in Oracle 12.1.0.2 anymore but did exist in Oracle 11.2.0.4 (without PSUs):

CWM2_OLAP_INSTALLER
DBMS_AMD
DBMS_APPCTX
DBMS_DBLINK
DBMS_DM_IMP_INTERNAL
DBMS_DM_UTIL_INTERNAL
DBMS_DUMA_INTERNAL
DBMS_JDM_INTERNAL
DBMS_RULE_COMPATIBLE_90
… Continue reading...
Mike Dietrich
Oracle Senior Director of Product Manager for Database Upgrade, Migrations and Patching writing just another blog.

Opinions certainly are my own as is this page.

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Join 7,349 other subscribers

Follow me on Twitter