DECLARE
BEGIN
EXECUTE IMMEDIATE
'
CREATE TABLE FSI_DE_MIGRATION_UNION AS

SELECT JURISDICTION_CODE
  ,UNION_DE_CODE
  ,UNION_METADATA
  ,CHILD_DE_CODE
  ,CHILD_METADATA
FROM VW_FSI_DE_MIGRATION_UNION_DE
WHERE 1 = 2

';
EXCEPTION
WHEN OTHERS THEN
  IF SQLCODE = -955 THEN
    EXECUTE IMMEDIATE
    'TRUNCATE TABLE FSI_DE_MIGRATION_UNION';
  ELSE
    RAISE;
  END IF;
END;
/