home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a523 / 22.ddi / DROPCAT5.SQL < prev    next >
Encoding:
Text File  |  1988-08-10  |  3.0 KB  |  104 lines
  1. Rem Copyright (c) 1988 by Oracle Corporation
  2. Rem NAME
  3. Rem    dropcat5.sql
  4. Rem  FUNCTION
  5. Rem    Drop version 5 dictionary objects owned by SYSTEM
  6. Rem  NOTES
  7. Rem    This script should be run while logged-in as SYSTEM on a version 5
  8. Rem    database.  It drops all version 5 dictionary objects.
  9. Rem    If a user is about to perform a full database export of a
  10. Rem    version 5 database that will be imported into a version 6
  11. Rem    database, he should first run this script to prevent the export
  12. Rem    and later import of the old dictionary objects. 
  13. Rem    All version 6 dictionary objects are owned by SYS, while version 5
  14. Rem    dictionary objects are owned by SYSTEM. 
  15. Rem
  16. Rem  MODIFIED
  17. Rem   Mendels    07/26/88 - Creation
  18. Rem
  19. set echo on
  20. drop public synonym dual;
  21. drop public synonym taballoc;
  22. drop public synonym storage;
  23. drop public synonym extents;
  24. drop public synonym spaces;
  25. drop public synonym syscolumns;
  26. drop public synonym columns;
  27. drop public synonym syscatalog;
  28. drop public synonym catalog;
  29. drop public synonym sysindexes;
  30. drop public synonym indexes;
  31. drop public synonym views;
  32. drop public synonym sysviews;
  33. drop public synonym systabauth;
  34. drop public synonym syscolauth;
  35. drop public synonym sysuserlist;
  36. drop public synonym sysprogs;
  37. drop public synonym synonyms;
  38. drop public synonym publicsyn;
  39. drop public synonym privatesyn;
  40. drop public synonym tab;
  41. drop public synonym col;
  42. drop public synonym tabquotas;
  43. drop public synonym dtab;
  44. drop public synonym partitions;
  45. drop public synonym systaballoc;
  46. drop public synonym sysstorage;
  47. drop public synonym sysextents;
  48. drop public synonym sysuserauth;
  49. drop public synonym system_audit;
  50. drop public synonym default_audit;
  51. drop public synonym table_audit;
  52. drop public synonym audit_actions;
  53. drop public synonym audit_trail;
  54. drop public synonym sysaudit_trail;
  55. drop public synonym audit_dba;
  56. drop public synonym audit_exists;
  57. drop public synonym audit_connect;
  58. drop public synonym sessions;
  59. drop public synonym audit_access;
  60. drop public synonym clusters;
  61. drop public synonym clustercolumns;
  62. drop table dual;
  63. drop view taballoc;
  64. drop view storage;
  65. drop view extents;
  66. drop view spaces;
  67. drop view syscolumns;
  68. drop view columns;
  69. drop view syscatalog;
  70. drop view catalog;
  71. drop view sysindexes;
  72. drop view indexes;
  73. drop view views;
  74. drop view sysviews;
  75. drop view systabauth;
  76. drop view syscolauth;
  77. drop view sysuserlist;
  78. drop view sysprogs;
  79. drop view synonyms;
  80. drop view publicsyn;
  81. drop view privatesyn;
  82. drop view tab;
  83. drop view col;
  84. drop view tabquotas;
  85. drop table dtab;
  86. drop view partitions;
  87. drop view systaballoc;
  88. drop view sysstorage;
  89. drop view sysextents;
  90. drop view sysuserauth;
  91. drop view system_audit;
  92. drop view default_audit;
  93. drop view table_audit;
  94. drop table audit_actions;
  95. drop view audit_trail;
  96. drop view audit_dba;
  97. drop view audit_exists;
  98. drop view audit_connect;
  99. drop view sessions;
  100. drop view audit_access;
  101. drop view clusters;
  102. drop view clustercolumns;
  103. set echo off;
  104.