Global Temporary Table with column of type ROWID and Oracle Updates

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Tue, 16 Dec 2008 04:23:11 -0800 (PST)
Message-ID: <af8e3fe5-d2a6-4315-b9a6-74d93f937331@c36g2000prc.googlegroups.com>

All,

I have proposed a solution which uses a global temporary table to remember an updated record via its rowid. Concerns have been risen that this will cause trouble in case of an update of the Oracle version (currently 10.2.0.2) to another version with a changed format for ROWID type columns. My reply was that during an upgrade of DB software there will be no segments of the global temporary table because of the way Oracle allocates segments (see [1]): only on first insert in a session a segment will be allocated and consequently only then data blocks will be formatted. So there should be no issue at all even if the format of ROWID changes. Is my reasoning correct? (I could not find anything relevant to this in metalink.)

Thanks!

robert

[1] http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/schema.htm#sthref773 Received on Tue Dec 16 2008 - 06:23:11 CST

Original text of this message