Oracle Tech Zone

1. Prepare

In this Streams test environment, there are two databases called “strm1” and “strm2”, whose global name are “strm1.com” and “strm2.com” respectively. The source side is “strm1”, and target side is “strm2”. The synchronization level is SCHEMA level and double-directions replication.

1.1 Init parameter prerequisite (Both db)

a) global_names should be true . global_name =db_name+”.”+domain_name

ALTER system SET global_names=true;

Read more…

oracle说这是个bug，从9i开始所有平台都会涉及，验证一下
环境是上一篇的http://www.orafan.net/blog/78.html
Read more…

源：strm1
目标：strm2
DBAUSR schema级别的复制环境
Read more…

以后再整理，先写上
1. Prepare
1.1 Init parameter prerequisite (Both db)
Read more…

1. Prepare

In this Streams test environment, there are two databases called “strm1″ and “strm2″, whose global name are “strm1.com” and “strm2.com” respectively. The source side is “strm1″, and target side is “strm2″. The synchronization level is SCHEMA level and single -directions replication.

1.1 Init parameter prerequisite (Both db)

a) global_names should be true . global_name =db_name+”.”+domain_name

ALTER system SET global_names=true;

Read more…