Yes you can ...

Although if you will check out the ALTER TABLESPACE or CREATE TABLESPACE and
all the other Oracle Docs, the AUTOEXTEND is actually assigned to the
datafile instead of to the tablespace ...

It's a bit confusing but a bit logical as well, the tablespace itself is a
logical structure within Oracle while the datafile is a physical entity in
your OS, so technically, it is the datafile that is auto-extending, and as a
result, the tablespace as a whole ... The datafile is of course normally
associated to a filesystem/file in your OS ...

Taking it from the docs, you can have AUTOEXTEND ON when adding new
datafiles and using the ALTER TABLESPACE command or when creating a new
tablespace using CREATE TABLESPACE ... But if the datafile had already been
added, then you have to do this one instead ...

ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/users03.dbf'
AUTOEXTEND ON;

Try it out, just create a dummy tablespace and take it from there ...

I believe most of the DBAs are in holiday mode, am just one of the few who
can't keep my hands off the computer ...

Cheers,
EDWIN ONG UY

_____

"Choose a job you love, and you will never have to work a day in your life."
-- Confucius
"How do I work? I grope." -- Albert Einstein
"Experience is the best teacher, enrolling in the class is the biggest
problem." -- Anonymous


-----Original Message-----
From: MCCCLAYTON
[mailto:oracledba-ezmlmshield-x85771236.[Email address protected]
Sent: Tuesday, 28 December 2004 16:50 p.m.
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



Oracle LazyDBA home page