4. directly modify the tablespace resizing: (1) general tablespace: auto Scaling: Scaling; Disable auto Scaling: alterdatabasedatafileoracleapporadatatbs_sys_ptcl.dbfautoextendoff; specify the size: alter
4. directly modify the tablespace expansion: (1) general tablespace: automatic expansion: alter database datafile '/oracle/app/oradata/tbs_sys_ptcl.dbf' autoextend on; disable automatic expansion: alter database datafile '/oracle/app/oradata/tbs_sys_ptcl.dbf' autoextend off; Size: alter
4. directly modify the tablespace resizing:
(1) General tablespace:
Automatic Scaling: alter database datafile '/oracle/app/oradata/tbs_sys_ptcl.dbf' autoextend on;
Disable auto Scaling: alter database datafile '/oracle/app/oradata/tbs_sys_ptcl.dbf' autoextend off;
Specify the size: alter database datafile '/oracle/app/oradata/tbs_sys_ptcl.dbf' resize 50 m;
(2) Temporary tablespace
Automatic Scaling: alter database tempfile '/oracle/app/oradata/tbs_temp_ptcl.dbf' autoextend on;
Disable auto Scaling: alter database datafile '/oracle/app/oradata/tbs_sys_ptcl.dbf' autoextend off;
Specify the size: alter database tempfile '/oracle/app/oradata/tbs_temp_ptcl.dbf' resize 50 m;
(3) Search statement after resizing:
Select * from dba_tablespaces a where a. tablespace_name like '% PTCL ';
5. Add new data files to the tablespace
(1) General tablespace:
Specify the size: alter tablespace tbs_sys_ptcl add datafile '/oracle/oradata/ora242/YM_tbs/tbs_sys_ptcl.ora' size 50 M;
Automatic extension of alter tablespace tbs_sys_ptcl add datafile '/oracle/oradata/ora242/YM_tbs/tbs_sys_ptcl.ora' size 50 M
Autoextend on;
(2) Temporary tablespace
Specify the size: alter tablespace tbs_temp_ptcl add tempfile '/oracle/oradata/ora242/YM_tbs/tbs_temp_ptcl.dbf' size 50 M;
Automatic Scaling: alter tablespace tbs_temp_ptcl add tempfile '/oracle/oradata/ora242/YM_tbs/tbs_temp_ptcl.dbf' size 50 M
Autoextend on;
6. delete users and their tablespaces:
(1) Delete A User:
Drop user lbi_sys_ptcl cascade;
(2) Delete the tablespace:
Drop tablespace TBS_SYS_PTCL including contents and datafiles cascade constraints;
(3) Delete data files:
Alter database datafile '/oracle/oradata/ora242/YM_tbs/TBS_DW_YM.ora' offline drop;