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.