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