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