Shulou(Shulou.com)06/01 Report--

1. View all tablespace sizes

SQL > select tablespace_name,sum (bytes) / 1024 plus 1024 from dba_data_files group by tablespace_name

two。 The size of the table space that is already free

SQL > select tablespace_name,sum (bytes) / 1024 plus 1024 from dba_free_space group by tablespace_name

3. So using space can be calculated like this.

Select a. Tablespaceful name memorialtotalpenderfreemedtotallivefree used from

(select tablespace_name,sum (bytes) / 1024 Universe 1024 total from dba_data_files

Group by tablespace_name) a

(select tablespace_name,sum (bytes) / 1024 Universe 1024 free from dba_free_space

Group by tablespace_name) b

Where a.tablespace_name=b.tablespace_name

4.

Select tablespace_name,file_name from dba_data_files

5.

Meathod1: add data files to tablespaces

ALTER TABLESPACE USERS ADD DATAFILE'+ HISDATA/his/datafile/users01.DBF' SIZE 10240M

Meathod2: add data files and allow data files to grow automatically

ALTER TABLESPACE app_data ADD DATAFILE

'd:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ EDWTEST\ APP04.DBF' SIZE 50m

AUTOEXTEND ON NEXT 5M MAXSIZE 100M

Meathod3: allow existing data files to grow automatically

ALTER DATABASE DATAFILE'D:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ EDWTEST\ APP03.DBF'

AUTOEXTEND ON NEXT 5M MAXSIZE 100M

Meathod4: manually resize existing data files

ALTER DATABASE DATAFILE'D:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ EDWTEST\ APP02.DBF'

RESIZE 100M

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.