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