08_maintain_tbs_and_datafile

Chapter 8

08_maintain_tbs_and_datafile

Read-only tbs

alter tablespace userdata read only;

cause a checkpoint;

data available only for read operations

objects can be dropped from tablespace

还原的时候会很有用。

alter tablespace userdata offline;

alter tablespace userdata online;

Changing storage settings:

LMT

DMT (x)

Resizing a tablespace:

autoextend

alter database

add a data file using alter tablespace

dba_data_files

dba_free_space

dba_data_files  可以查看是否为AUTOEXTEND??

ALTER DATABASE DATAFILE '/SAFSF/XX.DBF' SIZE 100M AUTOEXTEND ON; 

dba_temp_files

v$tablespace

dba_tablespaces;