Re: Convert to Locally-Managed Tablespaces

Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Hi

> I am curious - why are you forced to keep
> segments in specifically named tablespaces.

This Concorde XAL application has an internal repository which stores information about physical segment structures (as tablespace name, initial & next extent etc).

And it can start reorganizing segments without any warning if it finds some inconsistencies between data dictionary and its own information.

So, we decided itīd be easier to move data back to original tablespaces instead of starting re-configuring the app (we have whole weekend to do the job).

> I think the ideal is to MINIMIZE records_per_block on
> such tables, then set pctfree to zero, then MOVE them,
> then set pctfree back to what it was. But if you do have
> any such tables, you might want to experiment.

Good point about pctfree, but how could minimize records_per_block help in this case? Iīve used it for optimizing bitmap indexes, but for table moving?

Tanel.

--=_edee31402c9af85caf20f865b36bcb87--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).