[php]
SQL> show user
USER is "SCOTT"
SQL> create table t as select * from emp;
Table created.
SQL> @roll.sql
NAME USN RSSIZE WRITES
------------------------------ ---------- ---------- ----------
SYSTEM 0 385024 7020
_SYSSMU1$ 1 1171456 956160
_SYSSMU2$ 2 188416 943404
_SYSSMU3$ 3 319488 1171200
_SYSSMU4$ 4 1171456 998598
_SYSSMU5$ 5 1171456 970452
_SYSSMU6$ 6 1171456 967354
_SYSSMU7$ 7 1171456 948962
_SYSSMU8$ 8 2220032 968382
_SYSSMU9$ 9 1171456 1101832
_SYSSMU10$ 10 3268608 1162138
11 rows selected.
SQL> insert into t select * from emp;
14 rows created.
SQL> commit;
Commit complete.
SQL> @roll.sql
NAME USN RSSIZE WRITES
------------------------------ ---------- ---------- ----------
SYSTEM 0 385024 7020
_SYSSMU1$ 1 1171456 956386
_SYSSMU2$ 2 188416 943458
_SYSSMU3$ 3 319488 1171318
_SYSSMU4$ 4 1171456 998794
_SYSSMU5$ 5 1171456 970562
_SYSSMU6$ 6 1171456 967580
_SYSSMU7$ 7 1171456 949072
_SYSSMU8$ 8 2220032 968608
_SYSSMU9$ 9 1171456 1101942
_SYSSMU10$ 10 3268608 1162248
11 rows selected.
SQL> alter table t nologging;
Table altered.
SQL> insert /*+ append */ into t select * from emp;
14 rows created.
SQL> commit;
Commit complete.
SQL> @roll.sql
NAME USN RSSIZE WRITES
------------------------------ ---------- ---------- ----------
SYSTEM 0 385024 7020
_SYSSMU1$ 1 1171456 957058
_SYSSMU2$ 2 188416 944334
_SYSSMU3$ 3 319488 1172750
_SYSSMU4$ 4 1171456 999406
_SYSSMU5$ 5 1171456 971234
_SYSSMU6$ 6 1171456 968252
_SYSSMU7$ 7 1171456 949744
_SYSSMU8$ 8 2220032 969280
_SYSSMU9$ 9 1171456 1102270
_SYSSMU10$ 10 3268608 1162920
11 rows selected.
SQL>
SQL> alter table t logging;
Table altered.
SQL> @roll.sql
NAME USN RSSIZE WRITES
------------------------------ ---------- ---------- ----------
SYSTEM 0 385024 7020
_SYSSMU1$ 1 1171456 957644
_SYSSMU2$ 2 188416 944920
_SYSSMU3$ 3 319488 1173392
_SYSSMU4$ 4 1171456 1000274
_SYSSMU5$ 5 1171456 972016
_SYSSMU6$ 6 1171456 969150
_SYSSMU7$ 7 1171456 950526
_SYSSMU8$ 8 2220032 970006
_SYSSMU9$ 9 1171456 1102740
_SYSSMU10$ 10 3268608 1164018
11 rows selected.
SQL> insert into t select * from emp;
14 rows created.
SQL> commit;
Commit complete.
SQL> @roll.sql
NAME USN RSSIZE WRITES
------------------------------ ---------- ---------- ----------
SYSTEM 0 385024 7020
_SYSSMU1$ 1 1171456 957840
_SYSSMU2$ 2 188416 945146
_SYSSMU3$ 3 319488 1173502
_SYSSMU4$ 4 1171456 1000500
_SYSSMU5$ 5 1171456 972126
_SYSSMU6$ 6 1171456 969376
_SYSSMU7$ 7 1171456 950636
_SYSSMU8$ 8 2220032 970060
_SYSSMU9$ 9 1171456 1102850
_SYSSMU10$ 10 3268608 1164136
11 rows selected.
SQL> insert /*+ append */ into t select * from
2 emp;
14 rows created.
SQL> commit;
Commit complete.
SQL> @roll
NAME USN RSSIZE WRITES
------------------------------ ---------- ---------- ----------
SYSTEM 0 385024 7020
_SYSSMU1$ 1 1171456 958036
_SYSSMU2$ 2 188416 945372
_SYSSMU3$ 3 319488 1173612
_SYSSMU4$ 4 1171456 1000726
_SYSSMU5$ 5 1171456 972236
_SYSSMU6$ 6 1171456 969602
_SYSSMU7$ 7 1171456 950746
_SYSSMU8$ 8 2220032 970114
_SYSSMU9$ 9 1171456 1102960
_SYSSMU10$ 10 3268608 1164528
11 rows selected.
SQL>
[/php]