Re: AUTOEXTEND with multiple datafiles

Here is the command,

ALTER TABLESPACE "tablespace_name" ADD DATAFILE 'datafile_name' SIZE 2000M AUTOEXTEND ON NEXT 100M MAXSIZE 4000M; Andy Marcelo
Oracle DBA Consultant

tim_romano_at_my-dejanews.com wrote in message <6oqdsq$p0d$1_at_nnrp1.dejanews.com>...
>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
>
>
>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 Tue Jul 21 1998 - 10:32:49 CDT