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

Extended tablespace

(1) add data files

Sql > alter tablesapce ts01 add datafile'Dposition size xx.dbf' 200m

(2) increase the size of the data file

Sql > alter tablespace ts01 datafile'Dposition resize xx.dbf' 200m

(3) set the automatic growth of files.

Sql > alter tablespace ts01 datafile'Dpart autoentend on next xx.dbf' maxsize 50m maxsize 500m

Note: ts01 refers to the table space name, D:/xx.dbf is the absolute path of the file, and 200m in (1) (2) refers to setting the size of the file.

(3) 50m refers to the automatically increasing step size, and 500m is the maximum size.

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.