Cleanup Instances from Dehydration Tables

Cleanup Instances from Dehydration tables:

TRUNCATE TABLE INSTANCE_PAYLOAD DROP storage;

TRUNCATE TABLE REFERENCE_INSTANCE DROP storage;

TRUNCATE TABLE REJECTED_MSG_NATIVE_PAYLOAD DROP storage;

TRUNCATE TABLE INSTANCE_PAYLOAD DROP storage;

TRUNCATE TABLE COMPOSITE_INSTANCE_FAULT DROP storage;

TRUNCATE TABLE COMPOSITE_SENSOR_VALUE DROP storage;

TRUNCATE TABLE COMPOSITE_INSTANCE_ASSOC DROP storage;

TRUNCATE TABLE COMPOSITE_INSTANCE DROP storage;

TRUNCATE TABLE AUDIT_TRAIL DROP storage;

TRUNCATE TABLE CUBE_INSTANCE DROP storage;

TRUNCATE TABLE CUBE_SCOPE DROP storage;

TRUNCATE TABLE AUDIT_DETAILS DROP storage;

DELETE FROM XML_DOCUMENT;

COMMIT;

/app/oracle/product/Middleware

Clean up the dehydration store database and the file system by executing the following statements:

--Schemas:

SQL> drop user "DEV_MDS" cascade;

SQL> drop user "DEV_ORABAM" cascade;

SQL> drop user "DEV_ORASDPM" cascade;

SQL> drop user "DEV_SOAINFRA" cascade;

SQL> delete from SCHEMA_VERSION_REGISTRY where OWNER like 'DEV%';

SQL> commit;

--Table spaces and data files:

SQL>DROP TABLESPACE DEV_IAS_ORASDPM INCLUDING CONTENTS AND DATAFILES;

SQL>DROP TABLESPACE DEV_IAS_TEMP INCLUDING CONTENTS AND DATAFILES;

SQL>DROP TABLESPACE DEV_MDS INCLUDING CONTENTS AND DATAFILES;

SQL>DROP TABLESPACE DEV_ORABAM INCLUDING CONTENTS AND DATAFILES;

SQL>DROP TABLESPACE DEV_SOAINFRA INCLUDING CONTENTS AND DATAFILES;