You need to set the autoextend property of the datafiles associated with
the tablespace

Regards
JAIMURUGAN

-----Original Message-----
From: MCCCLAYTON
[mailto:oracledba-ezmlmshield-x85771236.[Email address protected]
Sent: Tuesday, December 28, 2004 9:20 AM
To: LazyDBA Discussion
Subject: Altering a Live Tablespace to Autoextend



Can you take a live table space and do a Alter Tablespace XYZ
Autoextend 1m;
Or do I have to do something different?

Mark




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Confidentiality Statement:

This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under applicable laws. If you are not the intended recipient, please note that you are strictly prohibited from disseminating or distributing this information (other than to the intended recipient) or copying this information. If you have received this communication in error, please notify us immediately by return email.


Oracle LazyDBA home page