Objective: Release the space occupied by table having columns capable to store BLOB/CLOB data. The space is not released even after deleting the whole row from the table.
There are defined steps to execute after doing delete of Table rows. Steps are below :
Table Name : BLOB_OBJECT_TAB
Column Name : BLOB_OBJECT_TAB_COL
set serverout on
ALTER TABLE BLOB_OBJECT_TAB enable row movement;
ALTER TABLE BLOB_OBJECT_TAB SHRINK SPACE compact;
ALTER TABLE BLOB_OBJECT_TAB SHRINK SPACE;
ALTER TABLE BLOB_OBJECT_TAB MODIFY LOB(BLOB_OBJECT_TAB_COL) (SHRINK SPACE CASCADE);
alter table BLOB_OBJECT_TAB disable row movement;
ALTER INDEX PK_ID REBUILD;
ALTER TABLE BLOB_OBJECT_TAB disable row movement;
Datasource creation using python script. Python Script was failing after creating Datasource. From UI Admin Console, if I try to activat...
Topics Create a sample SOAP Webservice using JAX-WS Deploy in Tomcat 7.0 Invoke WSDL Create Client Use Client to invoke Webservice ...
Dead-letter queues The dead-letter queue (or undelivered-message queue) is the queue to which messages are sent if they cannot be routed to...
01002 A DISCONNECT error occurred. 01003 Null values were eliminated from the argument of a column function. 01004 The value of a string was...