Starting from Space Manager 5.7.3 and forward e.g. 6.x.
Below are the steps to recover and perform clean up before the switch. You need to drop the trigger, procedure, tables, sequences, and temp table.
Recovery for failure before switch
Not urgent! Table is available
1. Drop temporary posting objects
select a.owner, a.object_name, a.object_type
from dba_objects a, dba_objects b
where a.object_name like 'QUEST%' || to_char (b.object_id) || '%'
and b.owner = '&table_owner' and b.object_name = '&table_name' and b.object_type = 'TABLE' ;
Objects to drop:
drop trigger &spc_schema.quest_qsa_lwrt&obj# ;
drop procedure &spc_schema.quest_qsa_lwrp&obj# ;
drop table &spc_schema.quest_qsa_lwdata&obj# ;
drop table &spc_schema.quest_qsa_lwses&obj# ;
drop sequence &spc_schema.quest_qsa_lwsesseq&obj# ;
drop sequence &spc_schema.quest_qsa_lwtnumseq&obj# ;
2. Drop temporary table (other temporary objects will be dropped along with table)
Take drop statement from beginning of script section relating to this table
('&table_owner', '&table_&obj#_LR', 'table', false);