Re: Tablespace with more than one file
- From: Toon Koppelaars <toon@xxxxxxxxxxx>
- To: gheibia@xxxxxxxxx, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 12 Oct 2009 08:28:06 +0200
>
> 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:
