01. remove streams
EXEC DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION();
02. drop queue tables
select OWNER,NAME,QUEUE_TABLE from dba_queues where owner='';
then
exec DBMS_STREAMS_ADM.REMOVE_QUEUE('');
03 drop supplemental logging
select 'alter table '||owner||'.'||table_name||' drop supplemental log data (all) columns;' from DBA_LOG_GROUPS where owner='';
execuatable SQL statements will be the output. run them.
You are done.