Differences

New interesting underscores for more than 255 _FIX_CONTROLs

Posted on April 22, 2025 by Differences Optimizer Parameters 6

I keep saying this – we have the best and most skilled customers. Christian Klose from my Franconian home region contacted me via LinkedIn and asked for some assistance with an SR. I confess, I replied way too late (information overflow). But the finding Christian had is great to know. There are new interesting underscores for more than 255 _FIX_CONTROLs.

Why don’t you see them in ORAdiff?

As usual, I went to ORAdiff and tried to find out anything about these new _fix_control parameters. But I couldn’t find any indication for what Christian …

Continue reading...

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 Vice President of Product Management and Development for Database Upgrade, Cloud Migrations and Patching writing just another blog.

Opinions certainly are my own as is this page.

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Join 11.3K other subscribers