Re: Tablespace with more than one file
- From: Amir Gheibi <gheibia@xxxxxxxxx>
- To: Toon Koppelaars <toon@xxxxxxxxxxx>
- Date: Mon, 12 Oct 2009 14:30:11 +0800
Yea, But if I do that, Oracle just gonna continues writing the second file
automatically?
On Mon, Oct 12, 2009 at 2:28 PM, Toon Koppelaars <toon@xxxxxxxxxxx> wrote:
> But the question is how can I prevent the first file from growing? Should I
>> do anything at all or Oracle automatically continues writing on the new file
>> and abandon the first file (as it doesn't write anything there anymore)?
>>
>
> You need to set the AUTOEXTEND property of that datafile to OFF. Here's a
> url that describes that.
>
>
> http://hnawri.wordpress.com/2007/05/04/alter-datafile-from-autoextend-on-to-off/
>
>
> On Mon, Oct 12, 2009 at 8:02 AM, Amir Gheibi <gheibia@xxxxxxxxx> wrote:
>
>> Hi Listers,
>> I have a 10gR2 database running on a HP-UX (HP Unix B.11.11 U 9000/800
>> 1801480297). The server's file system allows only files with the maximum
>> size of 2G. My biggest tablespace has one file and right now is about 800 MB
>> in size.
>> I thought one way to do this is to add a new file to the tablespace. But
>> the question is how can I prevent the first file from growing? Should I do
>> anything at all or Oracle automatically continues writing on the new file
>> and abandon the first file (as it doesn't write anything there anymore)?
>>
>> Cheers,
>> Amir Gheibi
>>
>
>
>
> --
> Toon Koppelaars
> RuleGen BV
> +31-615907269
> Toon.Koppelaars@xxxxxxxxxxx
> www.RuleGen.com
> TheHelsinkiDeclaration.blogspot.com
>
> (co)Author: "Applied Mathematics for Database Professionals"
> www.RuleGen.com/pls/apex/f?p=14265:13
>
>
Other related posts:
