Oracle8 Core Technology Seminar E: Oracle8
Oracle8 -- -
Oracle8 -- -
SQL> select * from t; C1 ---------- abcde fghij klmno pqrst uvwxy SQL> create index t_ind on t(c1) reverse; SQL> select file_id,block_id from dba_extents where segment_name= T_IND ; FILE_ID BLOCK_ID ---------- ---------- 4 760 SQL> ALTER SYSTEM DUMP DATAFILE 4 BLOCK 761; Oracle8 -- -
INSERT ROOT BLOCK 51 BRANCH BLOCK 26 76 LEAF BLOCK 1-25 26-50 51-75 76- ORDNO=81 ORDNO=80 ORDNO=79 ORDNO=78 Oracle8 -- -
ROOT BLOCK BRANCH BLOCK LEAF BLOCK Oracle8 -- -
INSERT ROOT BLOCK BRANCH BLOCK 2 7 LEAF BLOCK 4 Oracle8 -- -
ROOT BLOCK BRANCH BLOCK LEAF BLOCK Oracle8 -- -
Oracle8 -- -
Oracle8 -- -
Node2 DATA2 H P S Node1 DATA1 ORDERS Ethernet Oracle8 -- -
Oracle8 -- - INSERT 2
Oracle8 -- -
Oracle8 -- -
Oracle8 -- -
Oracle8 -- -
GC_DEFER_TIME (init.ora 1/100 INSERT Oracle8 -- -
Oracle8 -- -
Tips Oracle8 -- -
Oracle8 -- -