00059.Oracle创建数据字典管理的表空间

 

SQL> desc dict

 Name         Null?    Type

 ------------ -------- ------------------

 TABLE_NAME            VARCHAR2(30)

 COMMENTS               VARCHAR2(40000)

 

SQL> select table_name from dict where table_name like '%TABLESPACE%';

 

TABLE_NAME

--------------------------------

DBA_FILE_GROUP_TABLESPACES

DBA_HIST_TABLESPACE_STAT

DBA_TABLESPACES

DBA_TABLESPACE_GROUPS

DBA_TABLESPACE_THRESHOLDS

DBA_TABLESPACE_USAGE_METRICS

USER_FILE_GROUP_TABLESPACES

USER_TABLESPACES

ALL_FILE_GROUP_TABLESPACES

V$TABLESPACE

GV$ENCRYPTED_TABLESPACES

V$ENCRYPTED_TABLESPACES

GV$TABLESPACE

SQL> desc dba_tablespaces;

 Name                          Null?    Type

 -----------------------       -------- ------------------

 TABLESPACE_NAME               NOT NULL VARCHAR2(30)

 BLOCK_SIZE                    NOT NULL NUMBER

 INITIAL_EXTENT                         NUMBER

 NEXT_EXTENT                            NUMBER

 MIN_EXTENTS                   NOT NULL NUMBER

 MAX_EXTENTS                            NUMBER

 MAX_SIZE                               NUMBER

 PCT_INCREASE                           NUMBER

 MIN_EXTLEN                             NUMBER

 STATUS                                 VARCHAR2(9)

 CONTENTS                               VARCHAR2(9)

 LOGGING                                VARCHAR2(9)

 FORCE_LOGGING                          VARCHAR2(3)

 EXTENT_MANAGEMENT                      VARCHAR2(10)

 ALLOCATION_TYPE                        VARCHAR2(9)

 PLUGGED_IN                             VARCHAR2(3)

 SEGMENT_SPACE_MANAGEMENT               VARCHAR2(6)

 DEF_TAB_COMPRESSION                    VARCHAR2(8)

 RETENTION                              VARCHAR2(11)

 BIGFILE                                VARCHAR2(3)

 PREDICATE_EVALUATION                   VARCHAR2(7)

 ENCRYPTED                              VARCHAR2(3)

 COMPRESS_FOR                           VARCHAR2(12)

SQL> select tablespace_name,block_size,extent_management,segment_space_management from dba_tablespaces;

 

TABLESPACE_NAME BLOCK_SIZE EXTENT_MANAGEMENT    SEGMENT_SPAC

--------------- ---------- -------------------- ------------

SYSTEM                8192 LOCAL                MANUAL

SYSAUX                8192 LOCAL                AUTO

UNDOTBS1              8192 LOCAL                MANUAL

TEMP                  8192 LOCAL                MANUAL

USERS                 8192 LOCAL                AUTO

ZCHBKJ                8192 LOCAL                AUTO

SQL> create tablespace test datafile '/home/oracle/oracle/oradata/test.dbf' size 1000m minimum extent 50k extent management dictionary default storage (initial 50k next 50k maxextents 1000 pctincrease 0)