home *** CD-ROM | disk | FTP | other *** search
/ Winzipper / Winzipper_ISO.iso / programming / oracle7 7.2 / DB / UTIL72 / DROPCAT6.SQL < prev    next >
Encoding:
Text File  |  1995-05-09  |  2.3 KB  |  71 lines
  1. rem 
  2. rem $Header: dropcat6.sql 7020100.1 94/09/23 22:14:36 cli Generic<base> $ 
  3. rem 
  4. Rem Copyright (c) 1992 by Oracle Corporation
  5. Rem NAME
  6. Rem    dropcat6.sql
  7. Rem  FUNCTION
  8. Rem    Drop version 6 dictionary objects owned by SYS
  9. Rem  NOTES
  10. Rem    This script should be run while logged-in as SYS on a version 6
  11. Rem    database.  It drops all version 6 dictionary objects.
  12. Rem    If a user is about to perform a full database export of a
  13. Rem    version 6 database that will be imported into a version 7
  14. Rem    database, he should first run this script to prevent the export
  15. Rem    and later import of the old dictionary objects. 
  16. Rem
  17. Rem  MODIFIED
  18. Rem     rlim       09/29/92 -  Creation 
  19. Rem
  20.  
  21. set echo on
  22. drop public synonym dual;
  23. drop public synonym ACCESSIBLE_TABLES;
  24. drop public synonym ACCESSIBLE_COLUMNS;
  25. drop public synonym CONSTRAINT_DEFS;
  26. drop public synonym CONSTRAINT_COLUMNS;
  27. drop public synonym USER_CROSS_REFS;
  28. drop public synonym USER_TAB_GRANTS;
  29. drop public synonym USER_TAB_GRANTS_MADE;
  30. drop public synonym ALL_TAB_GRANTS_MADE;
  31. drop public synonym USER_TAB_GRANTS_RECD;
  32. drop public synonym ALL_TAB_GRANTS_RECD;
  33. drop public synonym USER_COL_GRANTS;
  34. drop public synonym ALL_TAB_GRANTS;
  35. drop public synonym ALL_COL_GRANTS;
  36. drop public synonym USER_COL_GRANTS_MADE;
  37. drop public synonym ALL_COL_GRANTS_MADE;
  38. drop public synonym USER_COL_GRANTS_RECD;
  39. drop public synonym ALL_COL_GRANTS_RECD;
  40. drop public synonym USER_AUDIT_CONNECT;
  41. drop public synonym DBA_AUDIT_CONNECT;
  42. drop public synonym USER_AUDIT_RESOURCE;
  43. drop public synonym DBA_AUDIT_RESOURCE;
  44. drop public synonym DBA_AUDIT_DBA;
  45. drop public synonym USER_TAB_AUDIT_OPTS;
  46.  
  47. drop table dual;
  48. drop view ACCESSIBLE_TABLES;
  49. drop view CONSTRAINT_DEFS;
  50. drop view CONSTRAINT_COLUMNS;
  51. drop view USER_CROSS_REFS;
  52. drop view DBA_CROSS_REFS;
  53. drop view USER_TAB_GRANTS;
  54. drop view DBA_TAB_GRANTS;
  55. drop view USER_TAB_GRANTS_MADE;
  56. drop view ALL_TAB_GRANTS_MADE;
  57. drop view USER_TAB_GRANTS_RECD;
  58. drop view ALL_TAB_GRANTS_RECD;
  59. drop view USER_COL_GRANTS;
  60. drop view DBA_COL_GRANTS;
  61. drop view USER_COL_GRANTS_MADE;
  62. drop view ALL_COL_GRANTS_MADE;
  63. drop view USER_COL_GRANTS_RECD;
  64. drop view ALL_COL_GRANTS_RECD;
  65. drop view USER_AUDIT_CONNECT;
  66. drop view USER_AUDIT_RESOURCE;
  67. drop view DBA_AUDIT_DBA;
  68. drop view USER_TAB_AUDIT_OPTS;
  69. drop view DBA_TAB_AUDIT_OPTS;
  70. set echo off;
  71.