SQL Language (MOSC)

MOSC Banner

ALTER TABLE documentation discrepancy?

edited Oct 5, 2019 5:36PM in SQL Language (MOSC) 2 commentsAnswered

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)  );

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center