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.