Update cleanup script after branching from random order branch

utPLSQL · jgebal · Apr 3, 2019 · Mar 22, 2019 · Mar 23, 2019 · Mar 24, 2019
commit 5d3b18c35238eb38a8c468bc7d209076254276a2
diff --git a/development/cleanup.sh b/development/cleanup.sh
@@ -26,12 +26,12 @@ drop user ${UT3_USER} cascade;
 
 begin
   for i in (
-    select decode(owner,'PUBLIC','drop public synonym "','drop synonym "'||owner||'"."')|| synonym_name ||'"' drop_orphaned_synonym from dba_synonyms a
+    select decode(owner,'PUBLIC','drop public synonym "','drop synonym "'||owner||'"."')|| synonym_name ||'"' drop_orphaned_synonym, owner||'.'||synonym_name syn from dba_synonyms a
      where not exists (select 1 from dba_objects b where (a.table_name=b.object_name and a.table_owner=b.owner or b.owner='SYS' and a.table_owner=b.object_name) )
        and a.table_owner not in ('SYS','SYSTEM')
   ) loop
-    dbms_output.put_line(i.drop_orphaned_synonym);
     execute immediate i.drop_orphaned_synonym;
+    dbms_output.put_line('synonym '||i.syn||' dropped');
   end loop;
 end;
 /

diff --git a/development/template.env.sh b/development/template.env.sh
@@ -18,5 +18,3 @@ export UT3_TESTER_HELPER_PASSWORD=ut3
 export UT3_TABLESPACE=users
 export UT3_USER="UT3\$USER#"
 export UT3_USER_PASSWORD=ut3
-export UT3_TESTER_HELPER=ut3_tester_helper
-export UT3_TESTER_HELPER_PASSWORD=ut3