Oracle 10 Gb extended tablespace

Oracle 10 Gb extended tablespace 1. manually add the data file size www.2cto.com alter database datafile 'C: \ oracle \ product \ 10.2.0 \ oradata \ CC_DB \****. dbf'resize 100 M; 2. set the tablespace to automatically expand alter database datafile 'C: \ oracle \ product \ 10.2.0 \ oradata \ CC_DB \****. DBF 'autoextend on next 5 M maxsize unlimited; www.2cto.com 3. add a data file to the tablespace (this is recommended) alter tablesapce *** add datafile 'C: \ oracle \ product \ 10.2.0 \ oradata \ CC_DB \ test_1.dbf' size 2 M; alter database d Atafile 'C: \ oracle \ product \ 10.2.0 \ oradata \ CC_DB \ test_1.dbf' resize 100 M; check the status after adding: select ts #, round (bytes/1024/1024 ), name from v $ datafile order by ts #; change the tablespace name alter tablespace test1 rename to test2; view the tablespace Information select * from dba_tablespace; PS: if an error occurs, use the specified user to log on and run the command again.