Home » Other » Community Hangout » Show us what you do! (N/A)
Show us what you do! [message #671155] Thu, 16 August 2018 09:08 Go to previous message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
I was perusing Richard Foote's Index Internals PDF from a link supplied by Ed Stevens here.

Can you spot the deliberate mistake? Wink
SQL> CREATE TABLE test_delete (id NUMBER, name VARCHAR2(10));
Table created.
SQL> CREATE INDEX test_delete_idx ON test_delete (name);
Index created.
SQL> INSERT INTO test_delete VALUES (1, 'BOWIE');
1 row created.
SQL> COMMIT;
Commit complete.
SQL> DELETE test_delete WHERE id = 1;
1 row updated.
SQL> SELECT file_id,block_id FROM dba_extents WHERE segment_name='TEST_DELETE_IDX';
FILE_ID BLOCK_ID
---------- --------------- 5 3441
SQL> ALTER SYSTEM DUMP DATAFILE 5 BLOCK 3442;
System altered.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: FIFA World cup - France vs Croatia
Next Topic: ODTUG Kscope, Orlando FL, next week
Goto Forum:
  


Current Time: Thu Jul 02 11:53:12 CDT 2020