home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a523 / 17.ddi / DBA_SYNO.SQL < prev    next >
Encoding:
Text File  |  1988-03-21  |  2.8 KB  |  128 lines
  1. remark    Copyright (c) 1988 by Oracle Corporation
  2. remark
  3. remark    NAME
  4. remark      DBA_SYNONYMS.SQL
  5. remark    FUNCTION
  6. remark      Creates private synonyms for DBA-only data dictionary views.
  7. remark    NOTES
  8. remark      Should be run in the account of every DBA user when created.
  9. remark    MODIFIED
  10. remark      Grayson    03/20/88 - Creation
  11. remark
  12. drop synonym DBA_CATALOG
  13. /
  14. create synonym DBA_CATALOG for SYS.DBA_CATALOG
  15. /
  16. drop synonym DBA_CLUSTERS
  17. /
  18. create synonym DBA_CLUSTERS for SYS.DBA_CLUSTERS
  19. /
  20. drop synonym DBA_CLU_COLUMNS
  21. /
  22. create synonym DBA_CLU_COLUMNS for SYS.DBA_CLU_COLUMNS
  23. /
  24. drop synonym DBA_COL_COMMENTS
  25. /
  26. create synonym DBA_COL_COMMENTS for SYS.DBA_COL_COMMENTS
  27. /
  28. drop synonym DBA_CROSS_REFS
  29. /
  30. create synonym DBA_CROSS_REFS for SYS.DBA_CROSS_REFS
  31. /
  32. drop synonym DBA_DATA_FILES
  33. /
  34. create synonym DBA_DATA_FILES for SYS.DBA_DATA_FILES
  35. /
  36. drop synonym DBA_DB_LINKS
  37. /
  38. create synonym DBA_DB_LINKS for SYS.DBA_DB_LINKS
  39. /
  40. drop synonym DBA_EXP_FILES
  41. /
  42. create synonym DBA_EXP_FILES for SYS.DBA_EXP_FILES
  43. /
  44. drop synonym DBA_EXP_TABLES
  45. /
  46. create synonym DBA_EXP_TABLES for SYS.DBA_EXP_TABLES
  47. /
  48. drop synonym DBA_EXP_VERSION
  49. /
  50. create synonym DBA_EXP_VERSION for SYS.DBA_EXP_VERSION
  51. /
  52. drop synonym DBA_EXTENTS
  53. /
  54. create synonym DBA_EXTENTS for SYS.DBA_EXTENTS
  55. /
  56. drop synonym DBA_FREE_SPACE
  57. /
  58. create synonym DBA_FREE_SPACE for SYS.DBA_FREE_SPACE
  59. /
  60. drop synonym DBA_INDEXES
  61. /
  62. create synonym DBA_INDEXES for SYS.DBA_INDEXES
  63. /
  64. drop synonym DBA_IND_COLUMNS
  65. /
  66. create synonym DBA_IND_COLUMNS for SYS.DBA_IND_COLUMNS
  67. /
  68. drop synonym DBA_OBJECTS
  69. /
  70. create synonym DBA_OBJECTS for SYS.DBA_OBJECTS
  71. /
  72. drop synonym DBA_SEQUENCES
  73. /
  74. create synonym DBA_SEQUENCES for SYS.DBA_SEQUENCES
  75. /
  76. drop synonym DBA_TAB_COLUMNS
  77. /
  78. create synonym DBA_TAB_COLUMNS for SYS.DBA_TAB_COLUMNS
  79. /
  80. drop synonym DBA_TAB_COMMENTS
  81. /
  82. create synonym DBA_TAB_COMMENTS for SYS.DBA_TAB_COMMENTS
  83. /
  84. drop synonym DBA_TAB_GRANTS
  85. /
  86. create synonym DBA_TAB_GRANTS for SYS.DBA_TAB_GRANTS
  87. /
  88. drop synonym DBA_ROLLBACK_SEGS
  89. /
  90. create synonym DBA_ROLLBACK_SEGS for SYS.DBA_ROLLBACK_SEGS
  91. /
  92. drop synonym DBA_SEGMENTS
  93. /
  94. create synonym DBA_SEGMENTS for SYS.DBA_SEGMENTS
  95. /
  96. drop synonym DBA_SYNONYMS
  97. /
  98. create synonym DBA_SYNONYMS for SYS.DBA_SYNONYMS
  99. /
  100. drop synonym DBA_SYS_AUDIT_OPTS
  101. /
  102. create synonym DBA_SYS_AUDIT_OPTS for SYS.DBA_SYS_AUDIT_OPTS
  103. /
  104. drop synonym DBA_TABLESPACES
  105. /
  106. create synonym DBA_TABLESPACES for SYS.DBA_TABLESPACES
  107. /
  108. drop synonym DBA_TABLES
  109. /
  110. create synonym DBA_TABLES for SYS.DBA_TABLES
  111. /
  112. drop synonym DBA_TAB_AUDIT_OPTS
  113. /
  114. create synonym DBA_TAB_AUDIT_OPTS for SYS.DBA_TAB_AUDIT_OPTS
  115. /
  116. drop synonym DBA_TS_QUOTAS
  117. /
  118. create synonym DBA_TS_QUOTAS for SYS.DBA_TS_QUOTAS
  119. /
  120. drop synonym DBA_USERS
  121. /
  122. create synonym DBA_USERS for SYS.DBA_USERS
  123. /
  124. drop synonym DBA_VIEWS
  125. /
  126. create synonym DBA_VIEWS for SYS.DBA_VIEWS
  127. /
  128.