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

ORACLE table space expansion method is what, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Step 1: check the name of the tablespace and the location of the file:

Select tablespace_name, file_id, file_name, round (bytes/ (1024,1024), 0) total_space from dba_data_files order by tablespace_name

Step 2: increase the required tablespace size:

New size of alter database datafile 'tablespace location' resize

For example:

Alter database datafile'\ oracle\ oradata\ anita_2008.dbf' resize 4000m

For oracle database tablespaces, in addition to manually increasing the size, you can also increase the data file and other ways to expand the tablespace size.

Method 1: increase the number of data files

Alter tablespace tablespace name add datafile 'new datafile address' size datafile size

For example:

Alter tablespace ESPS_2008 add datafile'\ oracle\ oradata\ anita_2010.dbf' size 1000m

Method 2: set the tablespace to expand automatically.

Alter database datafile 'data file location' autoextend on next automatic extension size maxsize maximum extension size

For example:

Alter database datafile'\ oracle\ oradata\ anita_2008.dbf' autoextend on next 100m maxsize 10000m

Method 3: query the use of tablespaces:

Select a.tablespaceName name. Bytes b.bytes/1024/1024 1024 "used MB", (a.bytes-b.bytes) / 1024 Universe 1024 "used MB", b.bytes/1024/1024 "free MB"

Round ((a.bytes-b.bytes) / a.bytes) * 100 used% 2) "used%" from

(select tablespace_name,sum (bytes) bytes from dba_data_files group by tablespace_name) a

(select tablespace_name,sum (bytes) bytes,max (bytes) largest from dba_free_space group by tablespace_name) b where a.tablespace_name=b.tablespace_name order by ((a.bytes-b.bytes) / a.bytes) desc

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

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.