ON CALL DBA SUPPORT

— Database blog

STEPS TO REMOVE STREAMS FROM THE DATABASE

Posted by ssgottik on 20/04/2011

     COMPLETELY REMOVE STREAMS FROM THE DATABASE

Starting from Oracle Database 10g, Oracle provides a means by which you can remove an entire Streams environment from a database.

Stop streams on both source and target and then execute the below command as sys user

SQL> conn sys@DBSOURCE as sysdba

SQL> execute DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION();

SQL> conn sys@DBTARGET as sysdba

SQL> execute DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION();

ISSUES:

In case if you get the $BIN error when you execute the above command , then purge the recycle bin and re-execute the above command.

SQL> purge dba_recyclebin;

Thanks and Regards,

Satish.G.S

Advertisements

One Response to “STEPS TO REMOVE STREAMS FROM THE DATABASE”

  1. Hello, yup this post is in fact nice and
    I have learned lot of things from it concerning blogging. thanks.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: