The Library is currently in the process of being upgraded from Oracle Database Version 18.104.22.168 to 22.214.171.124.
Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs,
and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Do you remember when mainframes were replaced by client-server? When
client-server was replaced by n-tier architecture? The "Cloud" is a
distraction ... DevOps is not. Prepare for the future.
Owned by SYS with no privileges granted
Writes the DDL for a heap table to create a partitioned table, insert the rows from the source table and collect table stats. Also performs a little renaming trick so that the partitioned table will appear to become the original table.
l_owner IN VARCHAR2,
l_table IN VARCHAR2,
partition_clause IN CLOB,
l_show_storage IN BINARY_INTEGER, -- 1 = generate the storage clause
table_def OUT CLOB);