【12c-体系结构篇】实验-管理表空间.pdf

默人

157

13页

4次

2022-10-16

5墨值下载

1表空间数据字典视图

如图，展示了表空间相关的数据字典视图信息：

2创建表空间

2.1本地管理的表空间

SQL>setlinesize200

SQL>createtablespacetest1datafile'/u01/app/oracle/oradata/orcl/test01.dbf'size50M;

Tablespacecreated.

SQL>select

tablespace_name,block_size,contents,extent_management,segment_space_managementfrom

dba_tablespaces;

TABLESPACE_NAME BLOCK_SIZECONTENTSEXTENT_MANSEGMEN

-----------------------------------------------------------------

SYSTEM    8192PERMANENTLOCALMANUAL

SYSAUX    8192PERMANENTLOCALAUTO

UNDOTBS1   8192UNDO LOCALMANUAL

TEMP    8192TEMPORARYLOCALMANUAL

USERS    8192PERMANENTLOCALAUTO

EXAMPLE   8192PERMANENTLOCALAUTO

TEST1    8192PERMANENTLOCALAUTO

7rowsselected.

创建表空间方式不指定段、区管理方式，采用默认。

SQL>createtablespacetest2datafile'/u01/app/oracle/oradata/orcl/test02.dbf'size100M

extentmanagementlocalsegmentspacemanagementauto;

Tablespacecreated.

SQL>select

tablespace_name,block_size,contents,extent_management,segment_space_managementfrom

dba_tablespaces;

TABLESPACE_NAME BLOCK_SIZECONTENTSEXTENT_MANSEGMEN

-----------------------------------------------------------------

SYSTEM    8192PERMANENTLOCALMANUAL

SYSAUX    8192PERMANENTLOCALAUTO

UNDOTBS1   8192UNDO LOCALMANUAL

TEMP    8192TEMPORARYLOCALMANUAL

USERS    8192PERMANENTLOCALAUTO

EXAMPLE   8192PERMANENTLOCALAUTO

TEST1    8192PERMANENTLOCALAUTO

TEST2    8192PERMANENTLOCALAUTO

8rowsselected.

2.2临时表空间

2.2.1查看系统默认临时表空间

SQL>colproperty_namefora40

SQL>colproperty_valuefora50

SQL>selectproperty_name,property_valueFROMdatabase_propertieswhere

property_name='DEFAULT_TEMP_TABLESPACE';

of 13

5墨值下载

oracle 体系结构

关注

评论