Re: swizzle?

From: Bill Pass <wbpass_at_yahoo.com>
Date: Wed, 19 Jun 2002 10:48:28 -0800
Message-ID: <F001.004819C3.20020619104828@fatcity.com>

Randomly mixing data with unpredictable results would be characteristic of a swizzle stick. Although the dictionary say's something about rum being involved. Probably required by the DBA who try's this without first taking a backup :)

>From a NOTE on metalink:

  When you create an object table, it automatically becomes referenceable,
  unless you use the OID AS clause when creating the table.
  The OID AS clause allows you to create an object table and to assign
  to the new table the same EOID as another object table of the same type.
  After you create a new table using the OID AS clause, you end up with
  two object table with the same EOID; the new table is not referenceable,
  the original one is. All references that used to point to the objects
  in the original table still reference the same objects in the same
  original table.

  If you execute this procedure on the new table, it will make the new
  table the referenceable table replacing the original one; thus, those
  references now point to the objects in the new table instead of the
  original table.

• Charlie Mengler <charliem_at_mwh.com> wrote:
  > 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!
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Charlie Mengler
  > INET: charliem_at_mwh.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).
  

  ---

Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pass
  INET: wbpass_at_yahoo.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 - 13:48:28 CDT