Thanks for the question, palanisamy.
Asked: March 12, 2018 - 9:58 am UTC
Last updated: September 30, 2022 - 4:20 am UTC
Version: 11g
Viewed 10K+ times! This question is
SQL> create table t (pk number primary key, x clob) 2 lob (x ) store as ( tablespace largets ) 3 partition by range (pk) 4 interval (1) 5 (partition p1 values less than (2) 6 ); Table created. SQL> SQL> insert into t values (1,rpad('x',32000,'x')); 1 row created. SQL> insert into t values (2,rpad('x',32000,'x')); 1 row created. SQL> insert into t values (3,rpad('x',32000,'x')); 1 row created. SQL> SQL> select table_name, partition_name, tablespace_name 2 from user_lob_partitions 3 order by partition_position; TABLE_NAME PARTITION_NAME TABLESPACE_NAME ------------------------------ ------------------------------ ------------------------ T P1 LARGETS T SYS_P16751 LARGETS T SYS_P16754 LARGETS 3 rows selected. SQL> SQL> alter table t modify default attributes lob (x ) ( tablespace users ); Table altered. SQL> SQL> insert into t values (4,rpad('x',32000,'x')); 1 row created. SQL> SQL> select table_name, partition_name, tablespace_name 2 from user_lob_partitions 3 order by partition_position; TABLE_NAME PARTITION_NAME TABLESPACE_NAME ------------------------------ ------------------------------ ------------------------ T P1 LARGETS T SYS_P16751 LARGETS T SYS_P16754 LARGETS T SYS_P16757 USERS 4 rows selected. SQL> SQL> SQL> SQL>
Serhat, September 29, 2022 - 8:18 am UTC
SQL> create table t (pk number primary key, x clob) 2 lob (x ) store as ( tablespace largets ) 3 / Table created.
Ayhan Orbay, September 29, 2022 - 8:19 am UTC
Need more information on Administration? Check out the Administrators guide for the Oracle Database