Drop all objects under schema

select 'drop  '||object_type||' '||owner||'.'||object_name||';' from dba_objects where OWNER= 'CAARS_DM_USER';

for sdwh refresh

select 'drop  '||object_type||' '||owner||'.'||object_name||';' from dba_objects where OWNER in ('CAARS_DM_USER','DM_PWR_USER','DM_USER','DPMS_DM_USER','DW_USER','EDQ','ETL','HARTS_DM_USER','HDD_DM_USER','HMA_CONTROL','HMA_CRM_USER','HMA_DM_INCENTIVES','HMA_DM_MARKETING','HMA_DM_SALES','HMA_DM_SERVICE','HMA_DM_SSBI','HMA_HIST','HMA_LOOKUP','HMA_MARKETING','HMA_ODS','HMA_PROD','HMA_STAGE','HMA_STG_MV_USER','INCENT_DM_USER','LMRS_DM_USER','MKTG_DM_USER','QIS_DM_USER','SALES_DM_USER','SCORE_DM_USER','SED_DM_USER','SSBI_DM_USER','VOC_DM_USER','WIS_DM_USER'
);