Re: segment issue
Date: Mon, 31 Oct 2011 09:45:34 -0700 (PDT)
Message-ID: <1320079534.95469.YahooMailNeo_at_web65409.mail.ac4.yahoo.com>
Please post the entire text of the alter table move command as well as the tablepace definitions and Oracle release in use (all 4 to 5 numbers). Your 'problem' still isn't clearly defined.
David Fitzjarrell
From: yang liu <ylouis83_at_gmail.com>
To: David Fitzjarrell <oratune_at_yahoo.com>
Sent: Monday, October 31, 2011 9:30 AM
Subject: Re: segment issue
That why after I alter xxx table move whitout changing the pctfree the segment size of the table become larger ? exactly from 55GB to 65GB
2011/11/1 David Fitzjarrell <oratune_at_yahoo.com>
A suggestion for what, exactly? Your problem is not clearly stated.
>
>
>David Fitzjarrell
>
>
>
>From: yang liu <ylouis83_at_gmail.com>
>To: oracle-l_at_freelists.org
>Sent: Monday, October 31, 2011 9:22 AM
>Subject: segment issue
>
>
>dba_segments,
>and I comfirm that the pctfree is not changed .the table is from 55GB to
>65GB
>Can anyone give me a suggestion? thanks
>
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 31 2011 - 11:45:34 CDT