...
Code Block | ||||
---|---|---|---|---|
| ||||
delete from FD.TEST_DEF_QUALIFIER_VALUE; delete from FD.ARC_TEST_DEF_QUAL_VALUE; delete from FD.TEST_RESULT; delete from FD.ARC_TEST_RESULT; delete from FD.TEST_DEFINITION_RUN; delete from FD.ARC_TEST_DEFINITION_RUN; delete from FD.TEST_SET_QUALIFIER_VALUE; delete from FD.ARC_TEST_SET_QUALIFIER_VALUE; delete from FD.TEST_SET_RUN; delete from FD.ARC_TEST_SET_RUN; delete from FD.TEST_RUN; delete from FD.ARC_TEST_RUN; delete from FD.PLUGIN_EXECUTION_OUTPUT_VALUE; delete from FD.ARC_PLUGIN_EXEC_OUTPUT_VALUE; delete from FD.PLUGIN_EXECUTION_OUTPUT; delete from FD.ARC_PLUGIN_EXECUTION_OUTPUT; delete from FD.PLUGIN_EXECUTION_LOG; delete from FD.ARC_PLUGIN_EXECUTION_LOG; delete from FD.PACKAGE_OBJECT_EXECUTION; delete from FD.ARC_PACKAGE_OBJECT_EXECUTION; delete from FD.PLUGIN_EXECUTION; delete from FD.ARC_PLUGIN_EXECUTION; delete from FD.WORKFLOW_EXECUTION_DATA; delete from FD.ARC_WORKFLOW_EXECUTION_DATA; delete from FD.WORKFLOW_EXECUTION; delete from FD.ARC_WORKFLOW_EXECUTION; delete from FD.WORKFLOW_REQUEST_INPUT; delete from FD.ARC_WORKFLOW_REQUEST_INPUT; delete from FD.SCHEDULED_TASK; delete from FD.ARC_SCHEDULED_TASK; delete from FD.HUMAN_TASK; delete from FD.ARC_HUMAN_TASK; delete from FD.FOLDER_REQUEST_CURRENT_STATE; delete from FD.PROJECT_WF_CURRENT_STATUS; delete from FD.PACKAGE_OBJ_CURRENT_STATUS; delete from FD.WORKFLOW_REQUEST_INST; delete from FD.ARC_WORKFLOW_REQUEST_INST; delete from FD.WORKFLOW_REQUEST_CMS_ISSUE; delete from FD.ARC_WORKFLOW_REQ_CMS_ISSUE; delete from FD.WORKFLOW_REQUEST; delete from FD.ARC_WORKFLOW_REQUEST; delete from FD.FOLDER_REQUEST; delete from FD.ARC_FOLDER_REQUEST; delete from FD.FOLDER_PROJECT_VERSION; delete from FD.ARC_FOLDER_PROJECT_VERSION; delete from FD.PROJECT_VERSION_DATA_VAL; delete from FD.ARC_PROJECT_VERSION_DATA_VAL; delete from FD.PROJECT_VERSION_DATA; delete from FD.ARC_PROJECT_VERSION_DATA; delete from FD.PACKAGE_OBJECT; delete from FD.ARC_PACKAGE_OBJECT; delete from FD.PROJECT_VERSION; delete from FD.ARC_PROJECT_VERSION; delete from FD.FOLDER_VERSION; delete from FD.ARC_FOLDER_VERSION; delete from FD.FOLDER_REQUEST_CURRENT_STATE; delete from FD.PROJECT_WF_CURRENT_STATUS; delete from FD.PACKAGE_OBJ_CURRENT_STATUS; delete from FD.PURGE_FOLDER_VERSION_KEY; delete from FD.PURGE_PROJ_VERSION_KEY; delete from FF.SEQUENCE_BLOCK where SEQ_NAM like 'stream-%'; delete from FD_ADMIN.PS_TXN; commit; |
...