home *** CD-ROM | disk | FTP | other *** search
/ Winzipper / Winzipper_ISO.iso / programming / oracle7 7.2 / DB / UTIL72 / CATNOREP.SQL < prev    next >
Encoding:
Text File  |  1995-05-09  |  1.4 KB  |  69 lines
  1. rem 
  2. rem $Header: catnorep.sql 7020200.1 95/02/15 18:32:52 cli Generic<base> $ 
  3. rem 
  4. Rem  Copyright (c) 1991 by Oracle Corporation 
  5. Rem    NAME
  6. Rem      catnorep.sql - Remove the objects catrepad.sql creates
  7. Rem    DESCRIPTION
  8. Rem      
  9. Rem    RETURNS
  10. Rem 
  11. Rem    NOTES
  12. Rem      This script expects to already be connected
  13. Rem    MODIFIED   (MM/DD/YY)
  14. Rem     echeng     02/10/95 -  add to 7.2 filelist
  15. Rem       hasun    10/20/94 -
  16.  
  17. ------------------------------------------------------------------------------
  18. --- Remove all database objects associated with Replication for Server Manager
  19. ------------------------------------------------------------------------------
  20. drop view DBA_ADMINSCHEMAS
  21. /
  22. drop view ALL_ADMINSCHEMAS
  23. /
  24. drop view USER_ADMINSCHEMAS
  25. /
  26. drop view DBA_ADMINOBJECTS
  27. /
  28. drop view ALL_ADMINOBJECTS
  29. /
  30. drop view USER_ADMINOBJECTS
  31. /
  32. drop view DBA_ADMINMASTERS
  33. /
  34. drop view ALL_ADMINMASTERS
  35. /
  36. drop view USER_ADMINMASTERS
  37. /
  38. drop view DBA_ADMINRESOLUTION
  39. /
  40. drop view ALL_ADMINRESOLUTION
  41. /
  42. drop view USER_ADMINRESOLUTION
  43. /
  44. drop view DBA_ADMINDEFTRAN
  45. /
  46. drop view DBA_ADMINDEFERROR
  47. /
  48. drop view DBA_ADMINCATLOG
  49. /
  50. drop view ALL_ADMINCATLOG
  51. / 
  52. drop view USER_ADMINCATLOG
  53. /
  54. drop view DBA_ADMINREGSNAPS
  55. /
  56. drop view ALL_ADMINREGSNAPS
  57. /
  58. drop view USER_ADMINREGSNAPS
  59. /
  60. drop package DBMS_DEFER_PRINT
  61. /
  62. drop table DEFCALLARGS
  63. /
  64. drop view DBA_ADMINARGUMENTS
  65. /
  66.  
  67. commit
  68. /
  69.