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

First, query the size of the table space and the file path address.

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

Solution one

/ / modify the tablespace size (32000 can be changed to the desired value) alter database datafile 'address of the data file to be modified' resize 32000m

Solution two

/ / add data file ALTER TABLESPACE tablespace name ADD DATAFILE 'data file path' SIZE 500MAUTOEXTEND ON NEXT 1m MAXSIZE UNLIMITED

Summary

The above are the two solutions to the shortage of Oracle table space introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply you in time. Thank you very much for your support to the website!

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.