WARNING: This web is not used anymore. Please use PDBService.StreamsConfiguration instead!

Oracle Streams configuration

The document StreamsReplication_unidir.doc includes:

  • an overview of replication using streams
  • replication environment configuration
  • scripts to join a database to the 3D replication testbed

The entry you should add to your tnsnames.ora file looks like:

       (ADDRESS = (PROTOCOL = TCP)(HOST = lxshare084d.cern.ch)(PORT =1521))
   (CONNECT_DATA = (SID = rls1))

Streams user and administrator PRIVILEGES

Streams USER PRIVILEGES (schema owner)

  • connect, resource
  • select_catalog_role (to look into data dictionary)
  • create and drop public synonym
  • exp_full_database and imp_full_database (to instantiate streams)


  • dba privilege is a requirement (Oracle 10g)
Topic attachments
I Attachment History Action Size Date Who Comment
Microsoft Word filedoc StreamsReplication_unidir.doc r1 manage 106.0 K 2006-04-04 - 17:39 EvaDafonte  
Unknown file formatsql addNewSchema.sql r1 manage 3.4 K 2006-04-06 - 15:47 EvaDafonte add new schema replication example
Unknown file formatsql create_strmadmin_10g.sql r1 manage 0.6 K 2006-04-04 - 17:41 EvaDafonte  
Unknown file formatsql create_strmadmin_9i.sql r1 manage 2.8 K 2006-04-04 - 17:41 EvaDafonte  
Unknown file formatsql setupStreams1dir_example.sql r2 r1 manage 5.3 K 2006-04-19 - 10:00 EvaDafonte  
Edit | Attach | Watch | Print version | History: r11 < r10 < r9 < r8 < r7 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r11 - 2006-04-19 - EvaDafonte
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2022 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback