Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3
Code Block
iSQL> select count(*) from temp01;
COUNT
-----------------------
0
1 row selected.
iSQL> exec testproc01(1000);
[ERR-11123 : The tablespace does not have enough free space ( TBS Name :TBS_DISK ).
0008 : INSERT INTO ATTR_SER ( OID_SER, PATH, TAG, FLAG, VR, VALUE )VALUES ( VOID_SER, TO_CHAR(J,'00'), 16642685, 0,
100000000004341);
      ^
                ^
]
iSQL> alter table attr_ser aging;
Alter success.
elapsed time : 0.02

iSQL> exec testproc01(1000);
[ERR-11123 : The tablespace does not have enough free space ( TBS Name :TBS_DISK ).
0008 : INSERT INTO ATTR_SER ( OID_SER, PATH, TAG, FLAG, VR, VALUE )VALUES ( VOID_SER, TO_CHAR(J,'00'), 16642685, 0,
100000000004341);
      ^
                ^
]

We performed aging on the table, but we could still not insert data.

Code Block
iSQL> desc attr_ser;
[ TABLESPACE : TBS_DISK ]
[ ATTRIBUTE ]
------------------------------------------------------------------------------
NAME                                     TYPE                        IS NULL
------------------------------------------------------------------------------
OID_SER                                  BIGINT                      NOT NULL
PATH                                     VARCHAR(248)                NOT NULL
TAG                                      INTEGER
FLAG                                     SMALLINT                    NOT NULL
VR                                       SMALLINT                    NOT NULL
VALUE                                    NIBBLE(254)
LOB                                      BLOB
[ INDEX ]
------------------------------------------------------------------------------
NAME                                     TYPE     IS UNIQUE     COLUMN
------------------------------------------------------------------------------
__SYS_IDX_ID_342                         BTREE    UNIQUE        OID_SER ASC,
                                                                PATH ASC
ADBS_NU_TBLATTR_SER_OID_SER_TAG          BTREE                  OID_SER ASC,
                                                                TAG ASC
[ PRIMARY KEY ]
------------------------------------------------------------------------------
OID_SER, PATH
iSQL>
iSQL>
iSQL> alter index __SYS_IDX_ID_342 aging;
Alter success.
elapsed time : 0.02

iSQL> exec testproc01(1000);
Execute success.
elapsed time : 0.39

After performing aging on Index, we were able to insert data.