??????????????е??????????????????DML????????磬?????????е????????
????SQL> delete from emp_load where rownum=1;
????delete from emp_load where rownum=1
????*
????ERROR at line 1:
????ORA-30657: operation not supported on external organized table
??????????????????????DML?????????????????????????????С????崠?????￡?
SQL> create table test as select * from emp_load where 1=0;
Table created.
SQL> INSERT /*+ APPEND */ INTO test select * from emp_load;
2899265 rows created.
Elapsed: 00:01:00.29
SQL> select * from test where rownum<=100;
select * from test where rownum<=100
*
ERROR at line 1:
ORA-12838: cannot read/modify an object after modifying it in parallel
SQL> commit;
Commit complete.
SQL> select * from test where rownum<=100;
???????????????????????????·????????????????????300????????????1?????????????????????????????????????????300M????棬?????Ч????????????
????SQL> show parameter memory
????NAME                     TYPE     VALUE
????------------------------------------ ----------- ------------------------------
????hi_shared_memory_address         integer     0
????memory_max_target             big integer 300M
????memory_target                 big integer 300M
????shared_memory_address             integer     0
??????????????????′??·???????????????????????·????????б??????SQL??????data buffer????????????????????buffer cache?????????￡?
SQL> conn /as sysdba
Connected.
SQL> alter system flush shared_pool;
System altered.
SQL> alter system flush buffer_cache;
System altered.
SQL> conn scott/tiger
Connected.
SQL> set timing on
SQL> insert into test select * from emp_load;
2899265 rows created.
Elapsed: 00:01:05.36
????????·?????????????redo??????????1??5??????????·??????????Ч???????????????????????С??????????????????·?????????????????
?????????SQL*PLUS?У?number??ε????????10?????????????937116510102250300????????????????????9.3712E+17?????????????set numwidth 18???????????number??ε????