Oracle-L: RE: swizzle?

From: Hately Mike <Mike.Hately_at_churchill.com>
Date: Wed, 19 Jun 2002 09:08:34 -0800
Message-ID: <F001.00481796.20020619090834@fatcity.com>

Wow,
I've never heard of this before but apparently it's :

swizzle v. To convert external names, array indices, or references within a data structure into address pointers when the data structure is brought into main memory from external storage (also called `pointer swizzling'); this may be done for speed in chasing references or to simplify code (e.g., by turning lots of name lookups into pointer dereferences). The converse operation is sometimes termed `unswizzling'.

Regards,
Mike

-----Original Message-----
Sent: 19 June 2002 16:23
To: Multiple recipients of list ORACLE-L

I'm RTFM the 9i R2 docs & I just read the following...

ALTER_TABLE_REFERENCEABLE Procedure
This procedure reorganizes object tables and swizzles references. For example, assume you have an object table FOO and that references in other tables point to objects stored in FOO. If you want to change some of the table organization--for example, you want to make it an IOT or a partitioned table, or you want to reorganize the data more efficiently--you copy all data from FOO into FOO2. Then you use the alter_table_referenceable and alter_table_not_referenceable procedures to swizzle all existing references to point to FOO2 instead of FOO.

I'd like to know the definition of "swizzle", 'cuz I just don't grok it used in this context.

Charlie Mengler                              Maintenance Warehouse  
charliem_at_mwh.com                             10641 Scripps Summit Ct.
858-831-2229                                 San Diego, CA 92131

There are no stupid questions, but there are many inquisitive idiots!

This email and any attached to it are confidential and intended only for the individual or
entity to which it is addressed. If you are not the intended recipient, please let us know
by telephoning or emailing the sender. You should also delete the email and any attachment
from your systems and should not copy the email or any attachment or disclose their content
to any other person or entity. The views expressed here are not necessarily those of
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England.
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Hately Mike
INET: Mike.Hately_at_churchill.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jun 19 2002 - 12:08:34 CDT