Oracle CDBVIEW_INTERNAL
Version 19.3

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose Supporting internal utilities for the CDBVIEW package.
AUTHID DEFINER
Dependencies
CDBVIEW DBMS_PDB_LIB  
Documented No
First Available 12.2.0.1
Security Model Owned by SYS with no privileges granted. This package is accessible only by the CDBVIEW package.
Source {ORACLE_HOME}/rdbms/admin/catcdbviews.sql
Subprograms
 
CREATE_CDBVIEW (new 19c)
Creates, or recreates, the CDB Views cdbview_internal.create_cdbView(
chk_upgrd    IN BOOLEAN,
owner        IN VARCHAR2,
oldview_name IN VARCHAR2,
newview_name IN VARCHAR2);

True indicates the call is part of an upgrade and the views are not recreated.
False indicates the call is not part of an upgrade and all CDB views are (re)created.
No demo possible due to the ACCESSIBLE BY clause.
 
LONG2VARCHAR2_I
Calls kpdbLong2Varchar2 in DBMS_PDB_LIB to convert a LONG to a VARCHAR2 cdbview_internal.long2varchar2_i(
stmt   IN     VARCHAR2,
rowid  IN     ROWID,
rowval IN OUT VARCHAR2);
No demo possible due to the ACCESSIBLE BY clause.

Related Topics
Built-in Functions
Built-in Packages
CDBVIEW
What's New In 18cR3
What's New In 19cR3

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved