The Select tablespace_name from dba_tablespace;
1) the SYSTEM table space - & gt; Table space have a lot of data dictionary, etc.
2) ROLL table space - & gt; Rollback tablespace MVCC (transaction mechanism version), remove the row locks, rollback segments, and the leave time (undo_retention appropriately supported ms)
3) temporary tablespace TEMP, temporary period, create a temporary table
4) the MAIN table space, this is the default database of white space, after the death of object to create tables and data, do not specify a storage location, the default stored in table space
5) HMAIN storing huge table table space
7) deleted tablespace
SQL> The drop in tablespace tbs3;
The drop in tablespace tbs3;
[3412] : trying to delete table space has been used.
SQL> The drop in tablespace TBS;
Delete the table space is empty table space
2, the clock space
Create a table space, initial size 50 m, the maximum 100 m
Dream without the concept of library database, from above, in the order: instance - user - table
Table space is the logical partition database, a table space can only belong to a database, all database objects stored in the specified in table space, but the main storage table, so called table space,
