select ‘drop table ‘||table_name||’;’ from user_tables;
drop table LOGSTDBY$EDS_TABLES;
drop table LOGSTDBY$HISTORY;
drop table LOGSTDBY$SKIP_SUPPORT;
drop table LOGSTDBY$SKIP;
drop table LOGSTDBY$SKIP_TRANSACTION;
drop table LOGSTDBY$PLSQL;
drop table LOGSTDBY$FLASHBACK_SCN;
drop table LOGSTDBY$SCN;
drop table LOGSTDBY$APPLY_MILESTONE;
drop table LOGSTDBY$EVENTS;
drop table LOGSTDBY$PARAMETERS;
drop table REPCAT$_SITES_NEW;
drop table REPCAT$_EXTENSION;
drop table REPCAT$_INSTANTIATION_DDL;
drop table REPCAT$_EXCEPTIONS;
drop table REPCAT$_TEMPLATE_TARGETS;
drop table REPCAT$_RUNTIME_PARMS;
drop table REPCAT$_SITE_OBJECTS;
drop table REPCAT$_TEMPLATE_SITES;
drop table REPCAT$_USER_PARM_VALUES;
drop table REPCAT$_OBJECT_PARMS;
drop table REPCAT$_TEMPLATE_PARMS;
drop table REPCAT$_TEMPLATE_OBJECTS;
drop table REPCAT$_TEMPLATE_REFGROUPS;
drop table REPCAT$_OBJECT_TYPES;
drop table REPCAT$_USER_AUTHORIZATIONS;
drop table REPCAT$_REFRESH_TEMPLATES;
drop table REPCAT$_TEMPLATE_TYPES;
drop table REPCAT$_TEMPLATE_STATUS;
drop table REPCAT$_FLAVOR_OBJECTS;
drop table REPCAT$_AUDIT_COLUMN;
drop table REPCAT$_AUDIT_ATTRIBUTE;
drop table REPCAT$_PARAMETER_COLUMN;
drop table REPCAT$_RESOL_STATS_CONTROL;
drop table REPCAT$_RESOLUTION_STATISTICS;
drop table REPCAT$_RESOLUTION;
drop table REPCAT$_RESOLUTION_METHOD;
drop table REPCAT$_CONFLICT;
drop table REPCAT$_GROUPED_COLUMN;
drop table REPCAT$_COLUMN_GROUP;
drop table REPCAT$_PRIORITY;
drop table REPCAT$_PRIORITY_GROUP;
drop table REPCAT$_REPGROUP_PRIVS;
drop table REPCAT$_DDL;
drop table REPCAT$_REPCATLOG;
drop table REPCAT$_REPPROP;
drop table REPCAT$_GENERATED;
drop table REPCAT$_KEY_COLUMNS;
drop table REPCAT$_REPCOLUMN;
drop table REPCAT$_REPOBJECT;
drop table REPCAT$_SNAPGROUP;
drop table REPCAT$_REPSCHEMA;
drop table REPCAT$_FLAVORS;
drop table REPCAT$_REPCAT;
drop table DEF$_DESTINATION;
drop table AQ$_INTERNET_AGENT_PRIVS;
drop table AQ$_INTERNET_AGENTS;
drop table AQ$_SCHEDULES;
drop table AQ$_QUEUES;
drop table AQ$_QUEUE_TABLES;
drop table MVIEW$_ADV_PLAN;
drop table MVIEW$_ADV_JOURNAL;
drop table MVIEW$_ADV_INFO;
drop table MVIEW$_ADV_PARAMETERS;
drop table MVIEW$_ADV_EXCEPTIONS;
drop table MVIEW$_ADV_OUTPUT;
drop table MVIEW$_ADV_ELIGIBLE;
drop table MVIEW$_ADV_CLIQUE;
drop table MVIEW$_ADV_GC;
drop table MVIEW$_ADV_FJG;
drop table MVIEW$_ADV_AJG;
drop table MVIEW$_ADV_ROLLUP;
drop table MVIEW$_ADV_LEVEL;
drop table MVIEW$_ADV_FILTERINSTANCE;
drop table MVIEW$_ADV_LOG;
drop table MVIEW$_ADV_FILTER;
drop table MVIEW$_ADV_TEMP;
drop table MVIEW$_ADV_PRETTY;
drop table MVIEW$_ADV_SQLDEPEND;
drop table MVIEW$_ADV_BASETABLE;
drop table MVIEW$_ADV_WORKLOAD;
drop table LOGMNR_SESSION$;
อีกอัน
select ‘drop table ‘||table_name||’;’ from user_tables where table_name like ‘SMP_%’;
