The Library is currently in the process of being upgraded from Oracle Database Version 22.214.171.124 to 126.96.36.199.
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.
Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news.
There is absolutely not a byte of truth to these irresponsible rumors.
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);