AUTOEXTEND with multiple datafiles

From: <tim_romano_at_my-dejanews.com>
Date: Sat, 18 Jul 1998 15:10:18 GMT
Message-ID: <6oqdsq$p0d$1@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 Sat Jul 18 1998 - 10:10:18 CDT