Drop Non-edition Public Synonyms (cdrdropnepubsynonym.sql)

  1. Download Oracle LSH 3.1 Patch p32078417_R12_GENERIC.zip.
  2. Unzip patch p32078417_R12_GENERIC.zip (DO NOT APPLY PATCH).
  3. Go to PATCH_Folder/32078417/cdr/patch/115/sql.
  4. Connect to the database as APPS user and run the cdrdropnepubsynonym.sql script.
  5. In the promt, enter Y.
  6. To verify whether or not the script has completed, run the following query to make sure there are no rows returned:
    SELECT owner, object_name, object_type
      FROM all_objects
      WHERE owner = 'PUBLIC'
          and (upper(object_name) like 'CDR_%' or upper(object_name) like 'DME_%')
          and OBJECT_TYPE= 'SYNONYM'
          and edition_name is null;
  7. Check the log file for any errors, and save it for future references. If you need help to fix any error, contact Health Sciences Support.