SQL> select 'spool drop_objects.log' 2 from dual 3 / spool drop_objects.log SQL> select 'drop '||object_type||' '||owner||'.'||object_name || decode(object_type, 2 'CLUSTER', ' including tables cascade constraints;', 3 'TABLE', ' cascade constraints;', ';') 4 from dba_objects 5 where object_type in ('MATERIALIZED VIEW', 'CLUSTER', 'TABLE', 'VIEW', 'SEQUENCE', 'SYNONYM', 'FUNCTION','PACKAGE','PROCEDURE','TRIGGER','LIBRARY') 6 and owner in ('MDMADM','CCBADM') 7 order by object_type 8 / drop TABLE MDMADM.F1_SCHEMA cascade constraints; drop TABLE MDMADM.F1_SVC_TASK cascade constraints; drop TABLE MDMADM.F1_SVC_TASK_CHAR cascade constraints; drop TABLE MDMADM.F1_SVC_TASK_K cascade constraints; drop TABLE MDMADM.F1_SVC_TASK_LOG cascade constraints; drop TABLE MDMADM.F1_SVC_TASK_LOG_PARM cascade constraints; drop TABLE MDMADM.F1_SVC_TASK_REL_OBJ cascade constraints; drop TABLE MDMADM.F1_SVC_TASK_TYPE cascade constraints; drop TABLE MDMADM.F1_SVC_TASK_TYPE_CHAR cascade constraints; drop TABLE MDMADM.F1_SVC_TASK_TYPE_L cascade constraints; drop TABLE MDMADM.F1_SYNC_REQ cascade constraints; drop TABLE MDMADM.F1_SYNC_REQ_CHAR cascade constraints; drop TABLE MDMADM.F1_SYNC_REQ_EXTRACT cascade constraints; drop TABLE MDMADM.F1_SYNC_REQ_IN cascade constraints; drop TABLE MDMADM.F1_SYNC_REQ_IN_BASIC cascade constraints; drop TABLE MDMADM.F1_SYNC_REQ_IN_CHAR cascade constraints; drop TABLE MDMADM.F1_SYNC_REQ_IN_EXCP cascade constraints; drop TABLE MDMADM.F1_SYNC_REQ_IN_EXCP_PARM cascade constraints; drop TABLE MDMADM.F1_SYNC_REQ_IN_K cascade constraints; drop TABLE MDMADM.F1_SYNC_REQ_IN_LOG cascade constraints; drop TABLE MDMADM.F1_SYNC_REQ_IN_LOG_PARM cascade constraints; drop TABLE MDMADM.F1_SYNC_REQ_IN_REL_OBJ cascade constraints; drop TABLE MDMADM.F1_SYNC_REQ_K cascade constraints; drop TABLE MDMADM.F1_SYNC_REQ_LOG cascade constraints; drop TABLE MDMADM.F1_SYNC_REQ_LOG_PARM cascade constraints; drop TABLE MDMADM.F1_TSPACE_ENTRY cascade constraints; drop TABLE MDMADM.F1_WEB_SVC cascade constraints; drop TABLE MDMADM.F1_WEB_SVC_CHAR cascade constraints; drop TABLE MDMADM.F1_WEB_SVC_L cascade constraints; drop TABLE MDMADM.F1_WEB_SVC_LOG cascade constraints; drop TABLE MDMADM.F1_WEB_SVC_LOG_PARM cascade constraints; drop TABLE MDMADM.F1_WEB_SVC_OPERATIONS cascade constraints; drop TABLE MDMADM.MDMADM_STATS_1 cascade constraints; drop TABLE MDMADM.MLOG$_D1_INIT_MSRMT_DATA cascade constraints; drop TABLE MDMADM.MLOG$_D1_MEASR_COMP cascade constraints; drop TABLE MDMADM.RUPD$_D1_INIT_MSRMT_DATA cascade constraints; drop TABLE MDMADM.RUPD$_D1_MEASR_COMP cascade constraints; drop TABLE MDMADM.SC_ACCESS_CNTL cascade constraints; drop TABLE MDMADM.SC_APP_SERVICE cascade constraints; drop TABLE MDMADM.SC_APP_SERVICE_L cascade constraints; drop TABLE MDMADM.SC_USER cascade constraints; drop TABLE MDMADM.SC_USER_CHAR cascade constraints; drop TABLE MDMADM.SC_USER_GROUP cascade constraints; drop TABLE MDMADM.SC_USER_GROUP_L cascade constraints; drop TABLE MDMADM.SC_USR_GRP_PROF cascade constraints; drop TABLE MDMADM.SC_USR_GRP_USR cascade constraints; drop TABLE MDMADM.TM_REG_CHAR_FIX cascade constraints; drop TABLE MDMADM.TM_ROLLOVER cascade constraints; drop TABLE MDMADM.XX_PENDING_STOP_SAS cascade constraints; drop TABLE MDMADM.F1_IWS_ANN_TYPE_PARM cascade constraints; drop TABLE MDMADM.F1_IWS_ANN_TYPE_PARM_L cascade constraints; drop TABLE MDMADM.F1_IWS_SVC cascade constraints; drop TABLE MDMADM.F1_IWS_SVC_ANN cascade constraints; drop TABLE MDMADM.F1_IWS_SVC_CHAR cascade constraints; drop TABLE MDMADM.F1_IWS_SVC_L cascade constraints; drop TABLE MDMADM.F1_IWS_SVC_LOG cascade constraints; drop TABLE MDMADM.F1_IWS_SVC_LOG_PARM cascade constraints; drop TABLE MDMADM.F1_IWS_SVC_OPER cascade constraints; drop TABLE MDMADM.F1_IWS_SVC_OPER_L cascade constraints; drop TABLE MDMADM.F1_KEY_HASH cascade constraints; drop TABLE MDMADM.F1_MANAG_CONTENT cascade constraints; drop TABLE MDMADM.F1_MANAG_CONTENT_L cascade constraints; drop TABLE MDMADM.F1_MAP cascade constraints; drop TABLE MDMADM.F1_MAP_L cascade constraints; drop TABLE MDMADM.F1_MAP_OVRD cascade constraints; drop TABLE MDMADM.F1_MD_DB_OBJ cascade constraints; drop TABLE MDMADM.F1_MIGR_DATA_ST cascade constraints; drop TABLE MDMADM.F1_MIGR_DATA_ST_ALG cascade constraints; drop TABLE MDMADM.F1_MIGR_DATA_ST_K cascade constraints; drop TABLE MDMADM.F1_MIGR_DATA_ST_LOG cascade constraints; drop TABLE MDMADM.F1_MIGR_DATA_ST_LOG_PARM cascade constraints; drop TABLE MDMADM.F1_MIGR_DATA_ST_TBL cascade constraints; drop TABLE MDMADM.F1_MIGR_OBJ cascade constraints; drop TABLE MDMADM.F1_MIGR_OBJ_ALG cascade constraints; drop TABLE MDMADM.F1_MIGR_OBJ_CLOB cascade constraints; drop TABLE MDMADM.F1_MIGR_OBJ_K cascade constraints; drop TABLE MDMADM.F1_MIGR_OBJ_LOG cascade constraints; drop TABLE MDMADM.F1_MIGR_OBJ_LOG_PARM cascade constraints; drop TABLE MDMADM.F1_MIGR_OBJ_SQL cascade constraints; drop TABLE MDMADM.F1_MIGR_OBJ_SQL_PK cascade constraints; drop TABLE MDMADM.F1_MIGR_PLAN cascade constraints; drop TABLE MDMADM.F1_MIGR_PLAN_INSTR cascade constraints; drop TABLE MDMADM.F1_MIGR_PLAN_INSTR_ALG cascade constraints; drop TABLE MDMADM.F1_MIGR_PLAN_INSTR_L cascade constraints; drop TABLE MDMADM.F1_MIGR_PLAN_L cascade constraints; drop TABLE MDMADM.F1_MIGR_REQ cascade constraints; drop TABLE MDMADM.F1_MIGR_REQ_INSTR cascade constraints; drop TABLE MDMADM.F1_MIGR_REQ_INSTR_ENTITY cascade constraints; drop TABLE MDMADM.F1_MIGR_REQ_INSTR_L cascade constraints; drop TABLE MDMADM.F1_MIGR_REQ_L cascade constraints; drop TABLE MDMADM.F1_MIGR_TRANS cascade constraints; drop TABLE MDMADM.F1_MIGR_TRANS_K cascade constraints; drop TABLE MDMADM.F1_MIGR_TRANS_LOG cascade constraints; drop TABLE MDMADM.F1_MIGR_TRANS_LOG_PARM cascade constraints; drop TABLE MDMADM.F1_MST_CONFIG cascade constraints; drop TABLE MDMADM.F1_OBJ_REV cascade constraints; drop TABLE MDMADM.F1_OBJ_REV_CHAR cascade constraints; drop TABLE MDMADM.F1_OBJ_REV_LOG cascade constraints; drop TABLE MDMADM.F1_OBJ_REV_LOG_PARM cascade constraints; drop TABLE MDMADM.F1_OUTMSG cascade constraints; drop TABLE MDMADM.F1_OUTMSG_ERRPARM cascade constraints; drop TABLE MDMADM.F1_OUTMSG_K cascade constraints; drop TABLE MDMADM.F1_OUTMSG_TYPE cascade constraints; drop TABLE MDMADM.F1_OUTMSG_TYPE_L cascade constraints; drop TABLE MDMADM.F1_REQ cascade constraints; drop TABLE MDMADM.F1_REQ_CHAR cascade constraints; drop TABLE MDMADM.F1_REQ_K cascade constraints; drop TABLE MDMADM.F1_REQ_LOG cascade constraints; drop TABLE MDMADM.F1_REQ_LOG_PARM cascade constraints; drop TABLE MDMADM.F1_REQ_TYPE cascade constraints; drop TABLE MDMADM.F1_REQ_TYPE_L cascade constraints; drop TABLE MDMADM.F1_REQ_TYPE_LOG cascade constraints; drop TABLE MDMADM.F1_REQ_TYPE_LOG_PARM cascade constraints; drop VIEW CCBADM.CI_ACCTG_DAYS_VW; drop VIEW CCBADM.CI_ACCT_CR_R_VW; drop VIEW CCBADM.CI_ACCT_FT_HST_VW; drop VIEW CCBADM.CI_ACDC_WOSA_VW; drop VIEW CCBADM.CI_ADJTSAT_S_VW; drop VIEW CCBADM.CI_ALG_ADHC_VW; drop VIEW CCBADM.CI_ALG_ADJT_VW; drop VIEW CCBADM.CI_ALG_BSBF_VW; drop VIEW CCBADM.CI_ALG_BSBS_VW; drop VIEW CCBADM.CI_ALG_CCAL_VW; drop VIEW CCBADM.CI_ALG_CNSMP_VW; drop VIEW CCBADM.CI_ALG_COCN_VW; drop VIEW CCBADM.CI_ALG_COEV_VW; drop VIEW CCBADM.CI_ALG_ERAC_VW; drop VIEW CCBADM.CI_ALG_FACM_VW; drop VIEW CCBADM.CI_ALG_GLAC_VW; drop VIEW CCBADM.CI_ALG_GVFM_VW; drop VIEW CCBADM.CI_ALG_IDFM_VW; drop VIEW CCBADM.CI_ALG_LPCC_VW; drop VIEW CCBADM.CI_ALG_LPCE_VW; drop VIEW CCBADM.CI_ALG_ODSP_VW; drop VIEW CCBADM.CI_ALG_PHFM_VW; drop VIEW CCBADM.CI_ALG_PKCC_VW; drop VIEW CCBADM.CI_ALG_PKEL_VW; drop VIEW CCBADM.CI_ALG_PPBR_VW; drop VIEW CCBADM.CI_ALG_PPOA_VW; drop VIEW CCBADM.CI_ALG_PSEG_VW; drop VIEW CCBADM.CI_ALG_PSPR_VW; drop VIEW CCBADM.CI_ALG_PYDT_VW; drop VIEW CCBADM.CI_ALG_SATBC_VW; drop VIEW CCBADM.CI_ALG_SATFT_VW; drop VIEW CCBADM.CI_ALG_SVCR_VW; drop VIEW CCBADM.CI_ALG_SVEV_VW; drop VIEW CCBADM.CI_ALG_XAR_VW; drop VIEW CCBADM.CI_BAL_CTL_MEM_VW; drop VIEW CCBADM.CI_BCHG_READ_VW; drop VIEW CCBADM.CI_BCHG_UP_READ_VW; drop VIEW CCBADM.CI_BSEG_READ_VW; drop VIEW CCBADM.CI_CASE_ST_ALG_VW; drop VIEW CCBADM.CI_CA_ACCT_HIS_VW; drop VIEW CCBADM.CI_CC_ACCT_HST_VW; drop VIEW CCBADM.CI_CEVTD_ACCHST_VW; drop VIEW CCBADM.CI_CEVT_ACCHST_VW; drop VIEW CCBADM.CI_CE_ACCT_HST_VW; drop VIEW CCBADM.CI_CFG_SPMR2_VW; drop VIEW CCBADM.CI_CFG_SPMR_VW; drop VIEW CCBADM.CI_CHTY_ACC_VW; drop VIEW CCBADM.CI_CHTY_ADJT_VW; drop VIEW CCBADM.CI_CHTY_BCTL_VW; drop VIEW CCBADM.CI_CHTY_BSCL_VW; drop VIEW CCBADM.CI_CHTY_DIV_VW; drop VIEW CCBADM.CI_CHTY_ITMTY_VW; drop VIEW CCBADM.CI_CHTY_ITM_VW; drop VIEW CCBADM.CI_CHTY_MTRTY_VW; drop VIEW CCBADM.CI_CHTY_MTR_VW; drop VIEW CCBADM.CI_CHTY_PER_VW; drop VIEW CCBADM.CI_CHTY_PREM_VW; drop VIEW CCBADM.CI_CHTY_SATY_VW; drop VIEW CCBADM.CI_CHTY_SA_VW; drop VIEW CCBADM.CI_CHTY_SCMT_VW; drop VIEW CCBADM.CI_CHTY_SPTY_VW; drop VIEW CCBADM.CI_CHTY_SP_VW; drop VIEW CCBADM.CI_CO_ACCT_HST_VW; drop VIEW CCBADM.CI_CPROC_ACCHST_VW; drop VIEW CCBADM.CI_CP_ACCT_HST_VW; drop VIEW CCBADM.CI_CR_ACCT_HST_VW; drop VIEW CCBADM.CI_CURRENCY_VW; drop VIEW CCBADM.CI_CURR_CUST_VW; drop VIEW CCBADM.CI_DEG_MONTH_VW; drop VIEW CCBADM.CI_DVTY_CHTY_VW; drop VIEW CCBADM.CI_FA_ACCT_HST_VW; drop VIEW CCBADM.CI_FT_GL_XTR_VW; drop VIEW CCBADM.CI_FT_PROC_VW; drop VIEW CCBADM.CI_ITEEVI_SP_VW; drop VIEW CCBADM.CI_ITEM_CHTY_VW; drop VIEW CCBADM.CI_ITEM_SP_E_VW; drop VIEW CCBADM.CI_LOOKUP; drop VIEW CCBADM.CI_MR_RTEGEN_VW; drop VIEW CCBADM.CI_MR_STGUP2_VW; drop VIEW CCBADM.CI_MR_STG_UP_VW; drop VIEW CCBADM.CI_MR_ST_EXC_VW; drop VIEW CCBADM.CI_MR_VW; drop VIEW CCBADM.CI_MTR_CHTY_VW; drop VIEW CCBADM.CI_MTR_CNFG2_VW; drop VIEW CCBADM.CI_MTR_CNFG_VW; drop VIEW CCBADM.CI_NT_UP_EXC_VW; drop VIEW CCBADM.CI_ODEVTD_ACCHST_VW; drop VIEW CCBADM.CI_ODEVT_ACCHST_VW; drop VIEW CCBADM.CI_ODPRC_ACCHST_VW; drop VIEW CCBADM.CI_OMS_DEVICE_VW; drop VIEW CCBADM.CI_OMS_FEEDER_VW; drop VIEW CCBADM.CI_OMS_PHONE_VW; drop VIEW CCBADM.CI_OMS_PRIC_VW; drop VIEW CCBADM.CI_OMS_PRIK_VW; drop VIEW CCBADM.CI_OMS_PRIM_VW; drop VIEW CCBADM.CI_PAY_TND_VW; drop VIEW CCBADM.CI_PAY_VW; drop VIEW CCBADM.CI_PA_ACCT_HST_VW; drop VIEW CCBADM.CI_PER_PRIM_VW; drop VIEW CCBADM.CI_PP_ACCT_HST_VW; drop VIEW CCBADM.CI_RC_ACCT_HIS_VW; drop VIEW CCBADM.CI_REGRD_SEL_VW; drop VIEW CCBADM.CI_ROOT_OBJ_VW; drop VIEW CCBADM.CI_RV_BF_RDR_VW; drop VIEW CCBADM.CI_RV_BF_TXE_VW; drop VIEW CCBADM.CI_RV_BF_VAL_VW; drop VIEW CCBADM.CI_SA_IREG_VW; drop VIEW CCBADM.CI_SA_RDR_VW; drop VIEW CCBADM.CI_SA_SP_DT_VW; drop VIEW CCBADM.CI_SA_TXE_VW; drop VIEW CCBADM.CI_SA_VAL_VW; drop VIEW CCBADM.CI_SCTY_VAL_VW; drop VIEW CCBADM.CI_SED_ACCT_HST_VW; drop VIEW CCBADM.CI_SE_ACCT_HST_VW; drop VIEW CCBADM.CI_SP_CHTY_VW; drop VIEW CCBADM.CI_SP_IT_EV_VW; drop VIEW CCBADM.CI_SP_MTR_EV_VW; drop VIEW CCBADM.CI_SV_ACCT_HST_VW; drop VIEW CCBADM.CI_USR_ACC_GRP_VW; drop VIEW CCBADM.CI_WE_ACCT_HST_VW; drop VIEW CCBADM.CI_WO_ACCT_HST_VW; drop VIEW CCBADM.F1_ATTACHMENT_VW; drop VIEW CCBADM.F1_BO_LIFECYCLE_STATUS_VW; drop VIEW CCBADM.F1_LCBO_AUTO_ALG_VW; drop VIEW CCBADM.F1_TD_FK_CHAR_ENTRY_VW; drop VIEW MDMADM.CI_LOOKUP; drop VIEW MDMADM.CI_ROOT_OBJ_VW; drop VIEW MDMADM.CI_SCTY_VAL_VW; drop VIEW MDMADM.CI_USR_ACC_GRP_VW; drop VIEW MDMADM.D1_CONTACT_VW; drop VIEW MDMADM.D1_DEVICE_VW; drop VIEW MDMADM.D1_INI_CONTACT_VW; drop VIEW MDMADM.D1_INI_DOE_VW; drop VIEW MDMADM.D1_INI_DO_VW; drop VIEW MDMADM.D1_INI_DVC_CFG_VW; drop VIEW MDMADM.D1_INI_DVC_VW; drop VIEW MDMADM.D1_INI_IE_VW; drop VIEW MDMADM.D1_INI_MC_VW; drop VIEW MDMADM.D1_INI_SP_VW; drop VIEW MDMADM.D1_INI_US_VW; drop VIEW MDMADM.D1_MEASR_COMP_VW; drop VIEW MDMADM.D1_ON_CONTACT_VW; drop VIEW MDMADM.D1_ON_DOE_VW; drop VIEW MDMADM.D1_ON_DO_VW; drop VIEW MDMADM.D1_ON_DVC_CFG_VW; drop VIEW MDMADM.D1_ON_DVC_VW; drop VIEW MDMADM.D1_ON_IE_VW; drop VIEW MDMADM.D1_ON_MC_VW; drop VIEW MDMADM.D1_ON_SP_VW; drop VIEW MDMADM.D1_ON_US_VW; drop VIEW MDMADM.D1_SP_VW; drop VIEW MDMADM.D1_US_VW; drop VIEW MDMADM.D2_MEASR_QTY_AGR_MV; drop VIEW MDMADM.D2_QUALITY_CNT_AGR_MV; drop VIEW MDMADM.D2_TIMELINES_CNT_AGR_MV; drop VIEW MDMADM.D2_TIMELINES_QTY_AGR_MV; drop VIEW MDMADM.F1_ATTACHMENT_VW; drop VIEW MDMADM.F1_BO_LIFECYCLE_STATUS_VW; drop VIEW MDMADM.F1_LCBO_AUTO_ALG_VW; drop VIEW MDMADM.F1_TD_FK_CHAR_ENTRY_VW; SQL> select 'spool off' from dual 2 / spool off SQL> spool off