Modify index tablespace in Oracle Database

The Oracle Database modifies the index tablespace, including modifying the table tablespace, modifying the index tablespace, and modifying the tablespace with the CLOB field.
Alter table space syntax

1. Modify the table tablespace.

1. Alter table TABLENAME move tablespace TABLESPACENAME;

2. Modify the index tablespace.

1. Alter IndexINDEXNAME rebuild tablespace TABLESPACENAME;

3. Modify the tablespace with the CLOB Field

1. Alter TableTABLENAMEMoveTablespace TABLESPACENAME lob (COLUMNNAME) storeAs(Tablespace TABLESPACENAME );

Example of modifying a tablespace

Modify Table

1. Select 'Alter table'| A. table_name |'Move tablespace workflow ;',
2. A. owner, a. table_name, a. tablespace_name, .*FromDba_tables
3. WhereA. Owner ='Ermis _ shansi'
4. Order ByA. owner, a. table_name;

Modify Index

1. Select 'Alter Index'| A. index_name |'Rebuild tablespace workflow ;',
2. A. owner, a. index_name, a. tablespace_name, .*FromDba_indexes
3. WhereA. Owner ='Ermis _ shansi'
4. Order ByA. owner, a. table_name;

Modify a clob Index

1. ALTER TABLEWF_H_PROCESSINSTATTRMOVETABLESPACE WORKFLOW
2. LOB (ATTRIBUTE) STOREAS(Tablespace workflow );

If you encounter a large field, add an attribute:

1. Select 'Alter Index'| A. index_name |'Rebuild tablespace VASD ;',
2. A. owner, a. index_name, a. tablespace_name, .*FromDba_indexes
3. WhereA. Owner ='Ms200bj1'
4. AndIndex_type ='Normal'
5. Order ByA. owner, a. table_name;
8. Select 'Alter Index'| A. index_name |'Rebuild tablespace VASD ;',
9. A. owner, a. index_name, a. tablespace_name, .*FromDba_indexes
10. WhereA. Owner ='Ms200bj1'
11. AndIndex_type ='Lob'
12. Order ByA. owner, a. table_name;

First, query all tables involving large fields.

1. SELECT DISTINCTA. table_name
2. FROMDba_indexes
3. WHEREA. owner ='Ms200bj1' ANDIndex_type ='Lob'

One by one