Answers for "change tablespace of a table in oracle"

oracle change tablespace size

ALTER TABLESPACE tablespace_name
    ADD DATAFILE 'path_to_datafile'
    SIZE size
    AUTOEXTEND ON;
Code language: SQL (Structured Query Language) (sql)

oracle table change tablespace lob column

alter table t move lob(y) store as ( tablespace users )