Home Explore Help
Register Sign In
neal
/
scripts
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 32e3985109
Branches Tags
scripts
/
LJCOPY
/
drop_objects.out

drop_objects.out 12 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289 
  1. SQL> select 'spool drop_objects.log'
    2. 

  2.   2  from dual
    3. 

  3.   3  /
    4. 

  4. spool drop_objects.log
    5. 

  5. SQL> select 'drop '||object_type||' '||owner||'.'||object_name || decode(object_type,
    6. 

  6.   2                  'CLUSTER', ' including tables cascade constraints;',
    7. 

  7.   3                  'TABLE', ' cascade constraints;', ';')
    8. 

  8.   4  from dba_objects
    9. 

  9.   5  where object_type in ('MATERIALIZED VIEW', 'CLUSTER', 'TABLE', 'VIEW', 'SEQUENCE', 'SYNONYM', 'FUNCTION','PACKAGE','PROCEDURE','TRIGGER','LIBRARY')
    10. 

  10.   6  and owner in ('MDMADM','CCBADM')
    11. 

  11.   7  order by object_type
    12. 

  12.   8  /
    13. 

  13. drop TABLE MDMADM.F1_SCHEMA cascade constraints;
    14. 

  14. drop TABLE MDMADM.F1_SVC_TASK cascade constraints;
    15. 

  15. drop TABLE MDMADM.F1_SVC_TASK_CHAR cascade constraints;
    16. 

  16. drop TABLE MDMADM.F1_SVC_TASK_K cascade constraints;
    17. 

  17. drop TABLE MDMADM.F1_SVC_TASK_LOG cascade constraints;
    18. 

  18. drop TABLE MDMADM.F1_SVC_TASK_LOG_PARM cascade constraints;
    19. 

  19. drop TABLE MDMADM.F1_SVC_TASK_REL_OBJ cascade constraints;
    20. 

  20. drop TABLE MDMADM.F1_SVC_TASK_TYPE cascade constraints;
    21. 

  21. drop TABLE MDMADM.F1_SVC_TASK_TYPE_CHAR cascade constraints;
    22. 

  22. drop TABLE MDMADM.F1_SVC_TASK_TYPE_L cascade constraints;
    23. 

  23. drop TABLE MDMADM.F1_SYNC_REQ cascade constraints;
    24. 

  24. drop TABLE MDMADM.F1_SYNC_REQ_CHAR cascade constraints;
    25. 

  25. drop TABLE MDMADM.F1_SYNC_REQ_EXTRACT cascade constraints;
    26. 

  26. drop TABLE MDMADM.F1_SYNC_REQ_IN cascade constraints;
    27. 

  27. drop TABLE MDMADM.F1_SYNC_REQ_IN_BASIC cascade constraints;
    28. 

  28. drop TABLE MDMADM.F1_SYNC_REQ_IN_CHAR cascade constraints;
    29. 

  29. drop TABLE MDMADM.F1_SYNC_REQ_IN_EXCP cascade constraints;
    30. 

  30. drop TABLE MDMADM.F1_SYNC_REQ_IN_EXCP_PARM cascade constraints;
    31. 

  31. drop TABLE MDMADM.F1_SYNC_REQ_IN_K cascade constraints;
    32. 

  32. drop TABLE MDMADM.F1_SYNC_REQ_IN_LOG cascade constraints;
    33. 

  33. drop TABLE MDMADM.F1_SYNC_REQ_IN_LOG_PARM cascade constraints;
    34. 

  34. drop TABLE MDMADM.F1_SYNC_REQ_IN_REL_OBJ cascade constraints;
    35. 

  35. drop TABLE MDMADM.F1_SYNC_REQ_K cascade constraints;
    36. 

  36. drop TABLE MDMADM.F1_SYNC_REQ_LOG cascade constraints;
    37. 

  37. drop TABLE MDMADM.F1_SYNC_REQ_LOG_PARM cascade constraints;
    38. 

  38. drop TABLE MDMADM.F1_TSPACE_ENTRY cascade constraints;
    39. 

  39. drop TABLE MDMADM.F1_WEB_SVC cascade constraints;
    40. 

  40. drop TABLE MDMADM.F1_WEB_SVC_CHAR cascade constraints;
    41. 

  41. drop TABLE MDMADM.F1_WEB_SVC_L cascade constraints;
    42. 

  42. drop TABLE MDMADM.F1_WEB_SVC_LOG cascade constraints;
    43. 

  43. drop TABLE MDMADM.F1_WEB_SVC_LOG_PARM cascade constraints;
    44. 

  44. drop TABLE MDMADM.F1_WEB_SVC_OPERATIONS cascade constraints;
    45. 

  45. drop TABLE MDMADM.MDMADM_STATS_1 cascade constraints;
    46. 

  46. drop TABLE MDMADM.MLOG$_D1_INIT_MSRMT_DATA cascade constraints;
    47. 

  47. drop TABLE MDMADM.MLOG$_D1_MEASR_COMP cascade constraints;
    48. 

  48. drop TABLE MDMADM.RUPD$_D1_INIT_MSRMT_DATA cascade constraints;
    49. 

  49. drop TABLE MDMADM.RUPD$_D1_MEASR_COMP cascade constraints;
    50. 

  50. drop TABLE MDMADM.SC_ACCESS_CNTL cascade constraints;
    51. 

  51. drop TABLE MDMADM.SC_APP_SERVICE cascade constraints;
    52. 

  52. drop TABLE MDMADM.SC_APP_SERVICE_L cascade constraints;
    53. 

  53. drop TABLE MDMADM.SC_USER cascade constraints;
    54. 

  54. drop TABLE MDMADM.SC_USER_CHAR cascade constraints;
    55. 

  55. drop TABLE MDMADM.SC_USER_GROUP cascade constraints;
    56. 

  56. drop TABLE MDMADM.SC_USER_GROUP_L cascade constraints;
    57. 

  57. drop TABLE MDMADM.SC_USR_GRP_PROF cascade constraints;
    58. 

  58. drop TABLE MDMADM.SC_USR_GRP_USR cascade constraints;
    59. 

  59. drop TABLE MDMADM.TM_REG_CHAR_FIX cascade constraints;
    60. 

  60. drop TABLE MDMADM.TM_ROLLOVER cascade constraints;
    61. 

  61. drop TABLE MDMADM.XX_PENDING_STOP_SAS cascade constraints;
    62. 

  62. drop TABLE MDMADM.F1_IWS_ANN_TYPE_PARM cascade constraints;
    63. 

  63. drop TABLE MDMADM.F1_IWS_ANN_TYPE_PARM_L cascade constraints;
    64. 

  64. drop TABLE MDMADM.F1_IWS_SVC cascade constraints;
    65. 

  65. drop TABLE MDMADM.F1_IWS_SVC_ANN cascade constraints;
    66. 

  66. drop TABLE MDMADM.F1_IWS_SVC_CHAR cascade constraints;
    67. 

  67. drop TABLE MDMADM.F1_IWS_SVC_L cascade constraints;
    68. 

  68. drop TABLE MDMADM.F1_IWS_SVC_LOG cascade constraints;
    69. 

  69. drop TABLE MDMADM.F1_IWS_SVC_LOG_PARM cascade constraints;
    70. 

  70. drop TABLE MDMADM.F1_IWS_SVC_OPER cascade constraints;
    71. 

  71. drop TABLE MDMADM.F1_IWS_SVC_OPER_L cascade constraints;
    72. 

  72. drop TABLE MDMADM.F1_KEY_HASH cascade constraints;
    73. 

  73. drop TABLE MDMADM.F1_MANAG_CONTENT cascade constraints;
    74. 

  74. drop TABLE MDMADM.F1_MANAG_CONTENT_L cascade constraints;
    75. 

  75. drop TABLE MDMADM.F1_MAP cascade constraints;
    76. 

  76. drop TABLE MDMADM.F1_MAP_L cascade constraints;
    77. 

  77. drop TABLE MDMADM.F1_MAP_OVRD cascade constraints;
    78. 

  78. drop TABLE MDMADM.F1_MD_DB_OBJ cascade constraints;
    79. 

  79. drop TABLE MDMADM.F1_MIGR_DATA_ST cascade constraints;
    80. 

  80. drop TABLE MDMADM.F1_MIGR_DATA_ST_ALG cascade constraints;
    81. 

  81. drop TABLE MDMADM.F1_MIGR_DATA_ST_K cascade constraints;
    82. 

  82. drop TABLE MDMADM.F1_MIGR_DATA_ST_LOG cascade constraints;
    83. 

  83. drop TABLE MDMADM.F1_MIGR_DATA_ST_LOG_PARM cascade constraints;
    84. 

  84. drop TABLE MDMADM.F1_MIGR_DATA_ST_TBL cascade constraints;
    85. 

  85. drop TABLE MDMADM.F1_MIGR_OBJ cascade constraints;
    86. 

  86. drop TABLE MDMADM.F1_MIGR_OBJ_ALG cascade constraints;
    87. 

  87. drop TABLE MDMADM.F1_MIGR_OBJ_CLOB cascade constraints;
    88. 

  88. drop TABLE MDMADM.F1_MIGR_OBJ_K cascade constraints;
    89. 

  89. drop TABLE MDMADM.F1_MIGR_OBJ_LOG cascade constraints;
    90. 

  90. drop TABLE MDMADM.F1_MIGR_OBJ_LOG_PARM cascade constraints;
    91. 

  91. drop TABLE MDMADM.F1_MIGR_OBJ_SQL cascade constraints;
    92. 

  92. drop TABLE MDMADM.F1_MIGR_OBJ_SQL_PK cascade constraints;
    93. 

  93. drop TABLE MDMADM.F1_MIGR_PLAN cascade constraints;
    94. 

  94. drop TABLE MDMADM.F1_MIGR_PLAN_INSTR cascade constraints;
    95. 

  95. drop TABLE MDMADM.F1_MIGR_PLAN_INSTR_ALG cascade constraints;
    96. 

  96. drop TABLE MDMADM.F1_MIGR_PLAN_INSTR_L cascade constraints;
    97. 

  97. drop TABLE MDMADM.F1_MIGR_PLAN_L cascade constraints;
    98. 

  98. drop TABLE MDMADM.F1_MIGR_REQ cascade constraints;
    99. 

  99. drop TABLE MDMADM.F1_MIGR_REQ_INSTR cascade constraints;
    100. 

  100. drop TABLE MDMADM.F1_MIGR_REQ_INSTR_ENTITY cascade constraints;
    101. 

  101. drop TABLE MDMADM.F1_MIGR_REQ_INSTR_L cascade constraints;
    102. 

  102. drop TABLE MDMADM.F1_MIGR_REQ_L cascade constraints;
    103. 

  103. drop TABLE MDMADM.F1_MIGR_TRANS cascade constraints;
    104. 

  104. drop TABLE MDMADM.F1_MIGR_TRANS_K cascade constraints;
    105. 

  105. drop TABLE MDMADM.F1_MIGR_TRANS_LOG cascade constraints;
    106. 

  106. drop TABLE MDMADM.F1_MIGR_TRANS_LOG_PARM cascade constraints;
    107. 

  107. drop TABLE MDMADM.F1_MST_CONFIG cascade constraints;
    108. 

  108. drop TABLE MDMADM.F1_OBJ_REV cascade constraints;
    109. 

  109. drop TABLE MDMADM.F1_OBJ_REV_CHAR cascade constraints;
    110. 

  110. drop TABLE MDMADM.F1_OBJ_REV_LOG cascade constraints;
    111. 

  111. drop TABLE MDMADM.F1_OBJ_REV_LOG_PARM cascade constraints;
    112. 

  112. drop TABLE MDMADM.F1_OUTMSG cascade constraints;
    113. 

  113. drop TABLE MDMADM.F1_OUTMSG_ERRPARM cascade constraints;
    114. 

  114. drop TABLE MDMADM.F1_OUTMSG_K cascade constraints;
    115. 

  115. drop TABLE MDMADM.F1_OUTMSG_TYPE cascade constraints;
    116. 

  116. drop TABLE MDMADM.F1_OUTMSG_TYPE_L cascade constraints;
    117. 

  117. drop TABLE MDMADM.F1_REQ cascade constraints;
    118. 

  118. drop TABLE MDMADM.F1_REQ_CHAR cascade constraints;
    119. 

  119. drop TABLE MDMADM.F1_REQ_K cascade constraints;
    120. 

  120. drop TABLE MDMADM.F1_REQ_LOG cascade constraints;
    121. 

  121. drop TABLE MDMADM.F1_REQ_LOG_PARM cascade constraints;
    122. 

  122. drop TABLE MDMADM.F1_REQ_TYPE cascade constraints;
    123. 

  123. drop TABLE MDMADM.F1_REQ_TYPE_L cascade constraints;
    124. 

  124. drop TABLE MDMADM.F1_REQ_TYPE_LOG cascade constraints;
    125. 

  125. drop TABLE MDMADM.F1_REQ_TYPE_LOG_PARM cascade constraints;
    126. 

  126. drop VIEW CCBADM.CI_ACCTG_DAYS_VW;
    127. 

  127. drop VIEW CCBADM.CI_ACCT_CR_R_VW;
    128. 

  128. drop VIEW CCBADM.CI_ACCT_FT_HST_VW;
    129. 

  129. drop VIEW CCBADM.CI_ACDC_WOSA_VW;
    130. 

  130. drop VIEW CCBADM.CI_ADJTSAT_S_VW;
    131. 

  131. drop VIEW CCBADM.CI_ALG_ADHC_VW;
    132. 

  132. drop VIEW CCBADM.CI_ALG_ADJT_VW;
    133. 

  133. drop VIEW CCBADM.CI_ALG_BSBF_VW;
    134. 

  134. drop VIEW CCBADM.CI_ALG_BSBS_VW;
    135. 

  135. drop VIEW CCBADM.CI_ALG_CCAL_VW;
    136. 

  136. drop VIEW CCBADM.CI_ALG_CNSMP_VW;
    137. 

  137. drop VIEW CCBADM.CI_ALG_COCN_VW;
    138. 

  138. drop VIEW CCBADM.CI_ALG_COEV_VW;
    139. 

  139. drop VIEW CCBADM.CI_ALG_ERAC_VW;
    140. 

  140. drop VIEW CCBADM.CI_ALG_FACM_VW;
    141. 

  141. drop VIEW CCBADM.CI_ALG_GLAC_VW;
    142. 

  142. drop VIEW CCBADM.CI_ALG_GVFM_VW;
    143. 

  143. drop VIEW CCBADM.CI_ALG_IDFM_VW;
    144. 

  144. drop VIEW CCBADM.CI_ALG_LPCC_VW;
    145. 

  145. drop VIEW CCBADM.CI_ALG_LPCE_VW;
    146. 

  146. drop VIEW CCBADM.CI_ALG_ODSP_VW;
    147. 

  147. drop VIEW CCBADM.CI_ALG_PHFM_VW;
    148. 

  148. drop VIEW CCBADM.CI_ALG_PKCC_VW;
    149. 

  149. drop VIEW CCBADM.CI_ALG_PKEL_VW;
    150. 

  150. drop VIEW CCBADM.CI_ALG_PPBR_VW;
    151. 

  151. drop VIEW CCBADM.CI_ALG_PPOA_VW;
    152. 

  152. drop VIEW CCBADM.CI_ALG_PSEG_VW;
    153. 

  153. drop VIEW CCBADM.CI_ALG_PSPR_VW;
    154. 

  154. drop VIEW CCBADM.CI_ALG_PYDT_VW;
    155. 

  155. drop VIEW CCBADM.CI_ALG_SATBC_VW;
    156. 

  156. drop VIEW CCBADM.CI_ALG_SATFT_VW;
    157. 

  157. drop VIEW CCBADM.CI_ALG_SVCR_VW;
    158. 

  158. drop VIEW CCBADM.CI_ALG_SVEV_VW;
    159. 

  159. drop VIEW CCBADM.CI_ALG_XAR_VW;
    160. 

  160. drop VIEW CCBADM.CI_BAL_CTL_MEM_VW;
    161. 

  161. drop VIEW CCBADM.CI_BCHG_READ_VW;
    162. 

  162. drop VIEW CCBADM.CI_BCHG_UP_READ_VW;
    163. 

  163. drop VIEW CCBADM.CI_BSEG_READ_VW;
    164. 

  164. drop VIEW CCBADM.CI_CASE_ST_ALG_VW;
    165. 

  165. drop VIEW CCBADM.CI_CA_ACCT_HIS_VW;
    166. 

  166. drop VIEW CCBADM.CI_CC_ACCT_HST_VW;
    167. 

  167. drop VIEW CCBADM.CI_CEVTD_ACCHST_VW;
    168. 

  168. drop VIEW CCBADM.CI_CEVT_ACCHST_VW;
    169. 

  169. drop VIEW CCBADM.CI_CE_ACCT_HST_VW;
    170. 

  170. drop VIEW CCBADM.CI_CFG_SPMR2_VW;
    171. 

  171. drop VIEW CCBADM.CI_CFG_SPMR_VW;
    172. 

  172. drop VIEW CCBADM.CI_CHTY_ACC_VW;
    173. 

  173. drop VIEW CCBADM.CI_CHTY_ADJT_VW;
    174. 

  174. drop VIEW CCBADM.CI_CHTY_BCTL_VW;
    175. 

  175. drop VIEW CCBADM.CI_CHTY_BSCL_VW;
    176. 

  176. drop VIEW CCBADM.CI_CHTY_DIV_VW;
    177. 

  177. drop VIEW CCBADM.CI_CHTY_ITMTY_VW;
    178. 

  178. drop VIEW CCBADM.CI_CHTY_ITM_VW;
    179. 

  179. drop VIEW CCBADM.CI_CHTY_MTRTY_VW;
    180. 

  180. drop VIEW CCBADM.CI_CHTY_MTR_VW;
    181. 

  181. drop VIEW CCBADM.CI_CHTY_PER_VW;
    182. 

  182. drop VIEW CCBADM.CI_CHTY_PREM_VW;
    183. 

  183. drop VIEW CCBADM.CI_CHTY_SATY_VW;
    184. 

  184. drop VIEW CCBADM.CI_CHTY_SA_VW;
    185. 

  185. drop VIEW CCBADM.CI_CHTY_SCMT_VW;
    186. 

  186. drop VIEW CCBADM.CI_CHTY_SPTY_VW;
    187. 

  187. drop VIEW CCBADM.CI_CHTY_SP_VW;
    188. 

  188. drop VIEW CCBADM.CI_CO_ACCT_HST_VW;
    189. 

  189. drop VIEW CCBADM.CI_CPROC_ACCHST_VW;
    190. 

  190. drop VIEW CCBADM.CI_CP_ACCT_HST_VW;
    191. 

  191. drop VIEW CCBADM.CI_CR_ACCT_HST_VW;
    192. 

  192. drop VIEW CCBADM.CI_CURRENCY_VW;
    193. 

  193. drop VIEW CCBADM.CI_CURR_CUST_VW;
    194. 

  194. drop VIEW CCBADM.CI_DEG_MONTH_VW;
    195. 

  195. drop VIEW CCBADM.CI_DVTY_CHTY_VW;
    196. 

  196. drop VIEW CCBADM.CI_FA_ACCT_HST_VW;
    197. 

  197. drop VIEW CCBADM.CI_FT_GL_XTR_VW;
    198. 

  198. drop VIEW CCBADM.CI_FT_PROC_VW;
    199. 

  199. drop VIEW CCBADM.CI_ITEEVI_SP_VW;
    200. 

  200. drop VIEW CCBADM.CI_ITEM_CHTY_VW;
    201. 

  201. drop VIEW CCBADM.CI_ITEM_SP_E_VW;
    202. 

  202. drop VIEW CCBADM.CI_LOOKUP;
    203. 

  203. drop VIEW CCBADM.CI_MR_RTEGEN_VW;
    204. 

  204. drop VIEW CCBADM.CI_MR_STGUP2_VW;
    205. 

  205. drop VIEW CCBADM.CI_MR_STG_UP_VW;
    206. 

  206. drop VIEW CCBADM.CI_MR_ST_EXC_VW;
    207. 

  207. drop VIEW CCBADM.CI_MR_VW;
    208. 

  208. drop VIEW CCBADM.CI_MTR_CHTY_VW;
    209. 

  209. drop VIEW CCBADM.CI_MTR_CNFG2_VW;
    210. 

  210. drop VIEW CCBADM.CI_MTR_CNFG_VW;
    211. 

  211. drop VIEW CCBADM.CI_NT_UP_EXC_VW;
    212. 

  212. drop VIEW CCBADM.CI_ODEVTD_ACCHST_VW;
    213. 

  213. drop VIEW CCBADM.CI_ODEVT_ACCHST_VW;
    214. 

  214. drop VIEW CCBADM.CI_ODPRC_ACCHST_VW;
    215. 

  215. drop VIEW CCBADM.CI_OMS_DEVICE_VW;
    216. 

  216. drop VIEW CCBADM.CI_OMS_FEEDER_VW;
    217. 

  217. drop VIEW CCBADM.CI_OMS_PHONE_VW;
    218. 

  218. drop VIEW CCBADM.CI_OMS_PRIC_VW;
    219. 

  219. drop VIEW CCBADM.CI_OMS_PRIK_VW;
    220. 

  220. drop VIEW CCBADM.CI_OMS_PRIM_VW;
    221. 

  221. drop VIEW CCBADM.CI_PAY_TND_VW;
    222. 

  222. drop VIEW CCBADM.CI_PAY_VW;
    223. 

  223. drop VIEW CCBADM.CI_PA_ACCT_HST_VW;
    224. 

  224. drop VIEW CCBADM.CI_PER_PRIM_VW;
    225. 

  225. drop VIEW CCBADM.CI_PP_ACCT_HST_VW;
    226. 

  226. drop VIEW CCBADM.CI_RC_ACCT_HIS_VW;
    227. 

  227. drop VIEW CCBADM.CI_REGRD_SEL_VW;
    228. 

  228. drop VIEW CCBADM.CI_ROOT_OBJ_VW;
    229. 

  229. drop VIEW CCBADM.CI_RV_BF_RDR_VW;
    230. 

  230. drop VIEW CCBADM.CI_RV_BF_TXE_VW;
    231. 

  231. drop VIEW CCBADM.CI_RV_BF_VAL_VW;
    232. 

  232. drop VIEW CCBADM.CI_SA_IREG_VW;
    233. 

  233. drop VIEW CCBADM.CI_SA_RDR_VW;
    234. 

  234. drop VIEW CCBADM.CI_SA_SP_DT_VW;
    235. 

  235. drop VIEW CCBADM.CI_SA_TXE_VW;
    236. 

  236. drop VIEW CCBADM.CI_SA_VAL_VW;
    237. 

  237. drop VIEW CCBADM.CI_SCTY_VAL_VW;
    238. 

  238. drop VIEW CCBADM.CI_SED_ACCT_HST_VW;
    239. 

  239. drop VIEW CCBADM.CI_SE_ACCT_HST_VW;
    240. 

  240. drop VIEW CCBADM.CI_SP_CHTY_VW;
    241. 

  241. drop VIEW CCBADM.CI_SP_IT_EV_VW;
    242. 

  242. drop VIEW CCBADM.CI_SP_MTR_EV_VW;
    243. 

  243. drop VIEW CCBADM.CI_SV_ACCT_HST_VW;
    244. 

  244. drop VIEW CCBADM.CI_USR_ACC_GRP_VW;
    245. 

  245. drop VIEW CCBADM.CI_WE_ACCT_HST_VW;
    246. 

  246. drop VIEW CCBADM.CI_WO_ACCT_HST_VW;
    247. 

  247. drop VIEW CCBADM.F1_ATTACHMENT_VW;
    248. 

  248. drop VIEW CCBADM.F1_BO_LIFECYCLE_STATUS_VW;
    249. 

  249. drop VIEW CCBADM.F1_LCBO_AUTO_ALG_VW;
    250. 

  250. drop VIEW CCBADM.F1_TD_FK_CHAR_ENTRY_VW;
    251. 

  251. drop VIEW MDMADM.CI_LOOKUP;
    252. 

  252. drop VIEW MDMADM.CI_ROOT_OBJ_VW;
    253. 

  253. drop VIEW MDMADM.CI_SCTY_VAL_VW;
    254. 

  254. drop VIEW MDMADM.CI_USR_ACC_GRP_VW;
    255. 

  255. drop VIEW MDMADM.D1_CONTACT_VW;
    256. 

  256. drop VIEW MDMADM.D1_DEVICE_VW;
    257. 

  257. drop VIEW MDMADM.D1_INI_CONTACT_VW;
    258. 

  258. drop VIEW MDMADM.D1_INI_DOE_VW;
    259. 

  259. drop VIEW MDMADM.D1_INI_DO_VW;
    260. 

  260. drop VIEW MDMADM.D1_INI_DVC_CFG_VW;
    261. 

  261. drop VIEW MDMADM.D1_INI_DVC_VW;
    262. 

  262. drop VIEW MDMADM.D1_INI_IE_VW;
    263. 

  263. drop VIEW MDMADM.D1_INI_MC_VW;
    264. 

  264. drop VIEW MDMADM.D1_INI_SP_VW;
    265. 

  265. drop VIEW MDMADM.D1_INI_US_VW;
    266. 

  266. drop VIEW MDMADM.D1_MEASR_COMP_VW;
    267. 

  267. drop VIEW MDMADM.D1_ON_CONTACT_VW;
    268. 

  268. drop VIEW MDMADM.D1_ON_DOE_VW;
    269. 

  269. drop VIEW MDMADM.D1_ON_DO_VW;
    270. 

  270. drop VIEW MDMADM.D1_ON_DVC_CFG_VW;
    271. 

  271. drop VIEW MDMADM.D1_ON_DVC_VW;
    272. 

  272. drop VIEW MDMADM.D1_ON_IE_VW;
    273. 

  273. drop VIEW MDMADM.D1_ON_MC_VW;
    274. 

  274. drop VIEW MDMADM.D1_ON_SP_VW;
    275. 

  275. drop VIEW MDMADM.D1_ON_US_VW;
    276. 

  276. drop VIEW MDMADM.D1_SP_VW;
    277. 

  277. drop VIEW MDMADM.D1_US_VW;
    278. 

  278. drop VIEW MDMADM.D2_MEASR_QTY_AGR_MV;
    279. 

  279. drop VIEW MDMADM.D2_QUALITY_CNT_AGR_MV;
    280. 

  280. drop VIEW MDMADM.D2_TIMELINES_CNT_AGR_MV;
    281. 

  281. drop VIEW MDMADM.D2_TIMELINES_QTY_AGR_MV;
    282. 

  282. drop VIEW MDMADM.F1_ATTACHMENT_VW;
    283. 

  283. drop VIEW MDMADM.F1_BO_LIFECYCLE_STATUS_VW;
    284. 

  284. drop VIEW MDMADM.F1_LCBO_AUTO_ALG_VW;
    285. 

  285. drop VIEW MDMADM.F1_TD_FK_CHAR_ENTRY_VW;
    286. 

  286. SQL> select 'spool off' from dual
    287. 

  287.   2  /
    288. 

  288. spool off
    289. 

  289. SQL> spool off
    290.