Tuesday 24 September 2013

Structure of dba_tablespace

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
 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)

No comments:

Post a Comment