Re: AUTOEXTEND with multiple datafiles

On Sat, 18 Jul 1998 15:10:18 GMT, tim_romano_at_my-dejanews.com wrote:

>When I run a select, my default TEMPORARY tablespace (a 2GB O/S datafile)is
>unable to extend sufficiently (error ORA-01630).
>
>The Oracle Complete Reference 3rd edition does not go into much detail in its
>explanation of ALTER TABLESPACE on p. 670 in situations where there is more
>than one underlying datafile, and I don't have a DBA Handbook with me. I want
>to make sure that the 2GB limit on the SUN box presents no special case.
>
>It looks easy enough to ADD a second 2GB datafile; there's plenty of space on
>the drive; but I'm not sure what to do about AUTOEXTEND, NEXT, and MAXSIZ.
>If I want to add another 2GB datafile (4GB total) and want the tablespace to
>grow as needed to occupy that entire 4GB space, would this be the correct
>command? And do I need to bring it offline first?
>
>
>ALTER TABLESPACE TempTableSpaceName
>ADD DATAFILE 'path/filename' SIZE 2000M
>AUTOEXTEND ON
>NEXT 100M
>MAXSIZ 4GB
>

maxsize refer to the max size of the datafile you're adding, it will be limited to 2G if you're not using Solaris 2.6. What you probably want to do is like this:

ALTER TABLESPACE TempTableSpaceName
ADD DATAFILE 'path/filename' SIZE 100m
AUTOEXTEND ON
NEXT 100M
MAXSIZ 2GB So this data file start with 100m, and can grow to 2G when needed.

>
>Thanks,
>Tim
>
>
>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Sun Jul 19 1998 - 15:50:12 CDT