1 row created.
SQL> commit;
Commit complete.
SQL> alter system switch logfile;
System altered.
在目标端查询：
[oracle@racogg ~]$ sqlplus
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 12 17:28:37 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter user-name: test Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from test;
no rows selected
SQL> select * from test;
STUID STUNAME STUPASSWD ---------- -------------------- -------------------- 1 test1 test1 数据已经同步过来，接下来测试ddl 在源端：
SQL> create table ddltest (ls number);
Table created.
在目标端查询表是否同步过来： SQL> select * from ddltest;
no rows selected
可以看到目标端已经有了ddltest表，然后在目标端向ddltest插入数据（只提交，不切换日志）：
SQL> insert into ddltest values(1);
1 row created.
SQL> commit;
Commit complete. 在目标端查询：
SQL> select * from ddltest;
LS ---------- 1
结果是即使源端不切换日志，目标端也同步过来.