Re: Global Temporary Table with column of type ROWID and Oracle Updates
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Thu, 5 Feb 2009 04:48:05 -0800 (PST)
Message-ID: <e01f08de-ec0b-4a3e-bb2b-4eb92a262739_at_r37g2000prr.googlegroups.com>
On Dec 17 2008, 10:00 am, Robert Klemme <shortcut..._at_googlemail.com> wrote:
> On Dec 17, 7:58 am,RobertKlemme <shortcut..._at_googlemail.com> wrote:
>
> > On 16.12.2008 20:11, joel garry wrote:
> > > Probably, but "Note:
>
> > > Segment shrink can be performed only on tables with row movement
> > > enabled. Applications that explicitly track rowids of objects cannot
> > > be shrunk, because the application tracks the physical location of
> > > rows in the objects.
> > > "
>
> > > Fromhttp://download.oracle.com/docs/cd/B19306_01/server.102/b14220/mgmt_d...
>
> > I did not think of this, thanks for the valuable heads up! Currently I
> > do not think that the table affected will benefit from shrinking as
> > there is not much deletion (if at all) going on. But I'll surely check
> > this!
>
> The table does not have row movement enabled anyway so online
> shrinking is not possible.
Date: Thu, 5 Feb 2009 04:48:05 -0800 (PST)
Message-ID: <e01f08de-ec0b-4a3e-bb2b-4eb92a262739_at_r37g2000prr.googlegroups.com>
On Dec 17 2008, 10:00 am, Robert Klemme <shortcut..._at_googlemail.com> wrote:
> On Dec 17, 7:58 am,RobertKlemme <shortcut..._at_googlemail.com> wrote:
>
> > On 16.12.2008 20:11, joel garry wrote:
> > > Probably, but "Note:
>
> > > Segment shrink can be performed only on tables with row movement
> > > enabled. Applications that explicitly track rowids of objects cannot
> > > be shrunk, because the application tracks the physical location of
> > > rows in the objects.
> > > "
>
> > > Fromhttp://download.oracle.com/docs/cd/B19306_01/server.102/b14220/mgmt_d...
>
> > I did not think of this, thanks for the valuable heads up! Currently I
> > do not think that the table affected will benefit from shrinking as
> > there is not much deletion (if at all) going on. But I'll surely check
> > this!
>
> The table does not have row movement enabled anyway so online
> shrinking is not possible.
Just in case anybody is interested in a solution: I put it online here:
http://ora-0815.blogspot.com/2009/01/table-history-with-twist.html
Enjoy
robert Received on Thu Feb 05 2009 - 06:48:05 CST