What is the extension method of ORACLE tablespace
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.
