Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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).Received on Tue Jan 06 2004 - 04:54:33 CST
![]() |
![]() |