Oracle Streams 11g Configuration (Schema Replication) Procedures
Prerequisite:
1. Create Tablespace for Oracle Streams administrator schema on both databases (SRC & DEST)
(which stores any objects created in the Oracle Streams administrator schema, including any spillover of messages from the buffered queues ownered by the schema. )
=> create tablespace streams_tbs datafile '+DATA' size 50M autoextend on next 10M maxsize unlimited default compress;
2. Create a new user to acts as the Oracle Streams administrator on both databases (SRC & DEST).
Prerequisite:
1. Create Tablespace for Oracle Streams administrator schema on both databases (SRC & DEST)
(which stores any objects created in the Oracle Streams administrator schema, including any spillover of messages from the buffered queues ownered by the schema. )
=> create tablespace streams_tbs datafile '+DATA' size 50M autoextend on next 10M maxsize unlimited default compress;
2. Create a new user to acts as the Oracle Streams administrator on both databases (SRC & DEST).
