ALTER TABLE documentation discrepancy?
I'm running Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production on Oracle Linux 7.
Wanted to rename the LOB segment name of a partitioned table (need to rename the table to create its copy), so checked the documentation: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/ALTER-TABLE.html#GUID-552E7373-BF93-477D-9DA3-B2C9…
.. and run:
CREATE TABLE scott.table_part_lob
( Time_Period VARCHAR2( 6 BYTE ) NOT NULL
, CI_NAME VARCHAR2(100 BYTE) NOT NULL
, QUANTITY NUMBER( 38, 19 ) NOT NULL
, ROW_CHANGELOG CLOB NULL
)
LOB (ROW_CHANGELOG) STORE AS SECUREFILE table_part_lob_LB1
PARTITION BY list (Time_Period) ( PARTITION MAX_VALUE VALUES (DEFAULT) );