spool SPMS_After_Import.txt

declare

cursor	driver is
select	job
from	user_jobs;

begin

   for driver_rec in driver LOOP
      dbms_job.remove (driver_rec.job);
   end loop;

end;
/
show error

def pac_index=app_index_medium
def pac_index=IDX_MED

@@c:\git\ddl\drop_all_db_links
@@c:\git\ddl\drop_all_constraints
@@c:\git\ddl\drop_all_indexes
@@c:\git\ddl\drop_all_synonyms

purge recyclebin;

@@c:\git\ddl\create_PKeys
@@c:\git\ddl\create_FKeys
@@c:\git\ddl\create_Indexes
@@c:\git\ddl\rebuild_CTX

@@c:\git\ddl\create_synonyms
@@c:\git\ddl\create_triggers

spool off

@c:\OraNT\re_compile
@c:\OraNT\re_compile

@u:\orant\jacow\jacow_db\set_params