Oracle DBMS_IAS_TEMPLATE
Version 19.2.0.1

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 Oracle Internet Application Server configuration utility. This package is not installed by default and must be manually installed from the Source file by SYS when connected to CDB$ROOT.

The following is copied from a service request opened at Oracle Support
Oracle decision was long ago made in an internal (unpublished) Bug 7676952 in which it is documented that package DBMS_IAS_TEMPLATE was removed starting 11.2.

By default, package
DBMS_IAS_TEMPLATE is not created unless script <dbmsiast.sql> is executed explicitly. This script can be safely removed.

Note: "unpublished". This package will be dropped from the Library with the release of version 20.
AUTHID DEFINER
Constants
Name Data Type Value
User Specified Objects
IAS_USER_DTYPE NUMBER -1001
IAS_SITEOWNER NUMBER -1002
READONLY_TABLE NUMBER -1003
SYNC_UPDATABLE_TABLE NUMBER -1005
TEMP_TABLE NUMBER -1011
USER_VIEW NUMBER 4
USER_SEQUENCE NUMBER 6
PLSQL_PROCEDURE NUMBER 7
PLSQL_FUNCTION NUMBER 8
PLSQL_PACKAGE NUMBER 9
Reserved For Future Use
ASYNC_UPDATABLE_TABLE NUMBER -1004
TYPE_OBJECT NUMBER 13
IAS objects created as part of the IAS instantiation process
ASYNC_MASTER_REPGROUP NUMBER -1012
SYNC_MASTER_REPGROUP NUMBER -1013
REFRESH_GROUP NUMBER -1014
UPDATABLE_MV_LOG NUMBER -1015
DUMMY_SNAPSHOT NUMBER -1016
GENERATED_DDL NUMBER -1017
Site Status
IAS_STATUS NUMBER -100
Dependencies Only STANDARD
Documented No
First Available Not Known
Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Source {ORACLE_HOME}/rdbms/admin/dbmsiast.sql

Unfortunately Oracle did not include the .PLB file with the package bodies so this package is now broken.
Opening an SR with Oracle so that they can either provide the body or drop the package definition.
Subprograms
 
CREATE_IAS_OBJECT
Add an object to an IAS template

Overload 1
dbms_ias_template.create_ias_object(
ias_template_name  IN VARCHAR2,
object_name        IN VARCHAR2,
object_type        IN VARCHAR2,
schema_name        IN VARCHAR2,
derived_from_sname IN VARCHAR2,
derived_from_oname IN VARCHAR2,
ddl_text           IN VARCHAR2)
RETURN NUMBER;
Broken by Oracle see SOURCE above.
Overload 2 dbms_ias_template.create_ias_object(
ias_template_name  IN VARCHAR2,
object_name        IN VARCHAR2,
object_type        IN NUMBER,
schema_name        IN VARCHAR2,
derived_from_sname IN VARCHAR2,
derived_from_oname IN VARCHAR2,
ddl_text           IN VARCHAR2)
RETURN NUMBER;
Broken by Oracle see SOURCE above.
Overload 3 dbms_ias_template.create_ias_object(
ias_template_name  IN VARCHAR2,
object_name        IN VARCHAR2,
object_type        IN NUMBER,
schema_name        IN VARCHAR2,
derived_from_sname IN VARCHAR2,
derived_from_oname IN VARCHAR2,
ddl_text           IN CLOB)
RETURN NUMBER;
Broken by Oracle see SOURCE above.
 
CREATE_IAS_TEMPLATE
Create a new IAS template dbms_ias_template.create_ias_template(
owner              IN VARCHAR2,
refresh_group_name IN VARCHAR2,
ias_template_name  IN VARCHAR2,
template_comments  IN VARCHAR2)
RETURN NUMBER;
Broken by Oracle see SOURCE above.
 
DROP_IAS_OBJECT
Drop an object from an IAS template

Overload 1
dbms_ias_template.drop_ias_object(
ias_template_name IN VARCHAR2,
object_name       IN VARCHAR2,
object_type       IN NUMBER,
schema_name       IN VARCHAR2);
Broken by Oracle see SOURCE above.
Overload 2 dbms_ias_template.drop_ias_object(
ias_template_name IN VARCHAR2,
object_name       IN VARCHAR2,
object_type       IN VARCHAR2,
schema_name       IN VARCHAR2);
Broken by Oracle see SOURCE above.
 
DROP_IAS_TEMPLATE
Drop an IAS template dbms_ias_template.drop_ias_template(ias_template_name IN VARCHAR2);
Broken by Oracle see SOURCE above.

Related Topics
Built-in Functions
Built-in Packages
DBMS_IAS_CONFIGURE
DBMS_IAS_QUERY
DBMS_IAS_SESSION
What's New In 18cR3
What's New In 19cR2

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