Generating a reorg script fails with the following:
Error storing script
ORA-04098: trigger 'QUEST_SCRIPT_B4I' is invalid and failed re-validation
Run the following while logged in as the Space Manager owner from SQLPlus to check the status of the trigger:
select owner, object_type, status from dba_objects where object_name='QUEST_SCRIPT_B4I';
If found invalid, run the following to recompile the trigger:
alter trigger QUEST_SCRIPT_B4I compile;
Check the status again by running the following and ensure status is now valid:
select owner, object_type, status from dba_objects where object_name='QUEST_SCRIPT_B4I';
If the status is still invalid or the recompile had some compilation errors, then it is recommended to reinstall the Space Manager objects - File | Admin | Reinstall Server.
