Re: Altering Freelist Groups in 10gR2 ?
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Sep 2006 10:47:14 +0100
The only option is to do the CTAS, as the freelist group
blocks are located immediately after the segment header
block in the first extent.
The only other option to consider is 'alter table move' to
move the table into a tablespace defined to use ASSM
and forget about freelist groups - but I'm not very keen
on ASSM for high-performance, high-concurrency systems
The Co-operative Oracle Users' FAQ
Cost Based Oracle: Fundamentals
----- Original Message -----
From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
Sent: Wednesday, September 27, 2006 10:42 AM
Subject: Altering Freelist Groups in 10gR2 ?
When converting a NON-RAC Database to RAC in 10.2, the freelist groups
need to be altered to 4(= to the Number of RAC Nodes)
How is the freelist groups to be altered?
Seek to avoid usage of the CTAS command i.e. "Create Table <Duplicate
Tbl Name with freelist groups 4> As Select * from Original Table" since
this is very tedious
Is there any performance issue/Others with using the alter approach
versus the CTAS approach?
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for
the use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further, you are
not to copy, disclose, or distribute this e-mail or its contents to any other
person and any such actions are unlawful. This e-mail may contain viruses.
Infosys has taken every reasonable precaution to minimize this risk, but is not
liable for any damage you may sustain as a result of any virus in this e-mail.
You should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content of all
messages sent to or from this e-mail address. Messages sent to or from this
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.12.9/457 - Release Date: 26/09/2006
Other related posts: