Extended tablespace of oracle learning records

Oracle learning records-extended tablespace oracle learning records-extended tablespaces: (1) adding tablespaces to data files; (2) modifying the size of data files, data files can be automatically expanded. Method 1 for extending table space at www.2cto.com: Use EM Control, database instance homepage, server tab, storage title, tablespace, add data file or redefinition size, and specify automatic expansion. The following describes how to use a statement: [SQL] -- connect to the database connect sys/oracle as sysdba as a sys user; -- The following shows a better view of the select statement. Col file_name for a46; col tablespace_name for a10; -- view the tablespace and its data files. The space size (unit: m) select tablespace_name, file_id, file_name, round (bytes/1024/1024, 0) as total_space from dba_data_files order by tablespace_name, file_id; -- extended tablespace Method 2: Modify the tablespace users, add the data file USERS1.DBF, And the size is 500 mb. This is especially applicable when the original disk is full, you need to use another disk-in Linux, You need to modify alter tablespace users add datafile 'C: \ ORACLEXE \ APP \ ORACLE \ ORADATA \ XE \ users1.dbf'si Ze 500 m; -- Method 3 for table space extension: Modify the database data file USERS. DBF, Which is expanded to 300 mb alter database datafile 'C: \ ORACLEXE \ APP \ ORACLE \ ORADATA \ XE \ USERS. dbf'resize 300 m; -- extended tablespace Method 4: Modify database data file USERS. DBF, which is automatically expanded to 100 MB at a time. The maximum value is 1000 MB. alter database datafile 'C: \ ORACLEXE \ APP \ ORACLE \ ORADATA \ XE \ USERS. DBF 'autoextend on next 100 m maxsize 1000 m; -- Methods 3 and 4 are usually used together.