A tablespace is not autoextendable but datafiles are. Use the
dba_data_files view to check if a datafile has the autoextend flag.

Eric

-----Original Message-----
From: David NGUYEN
[mailto:oracledba-ezmlmshield-x48552000.[Email address protected]
Sent: donderdag 30 november 2006 16:18
To: LazyDBA Discussion
Subject: autoextend on or off

hello experts

how can we know if tablespace is autoextend on or autoextend off
mode..?
what is the view to see this...?

thanks

david


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



The information included in this message is personal and/or
confidential and intended exclusively for the addressees as
stated. This message and/or the accompanying documents may contain
confidential information and should be handled accordingly. If you
are not the intended reader of this message, we urgently request
that you notify Centric immediately and that you delete this e-
mail and any copies of it from your system and destroy any
printouts immediately.
It is forbidden to distribute, reproduce, use or disclose the
information in this e-mail to third parties without obtaining
prior permission from Centric. We expressly point out that there
are risks associated with the use of e-mail. Centric and the
companies within the group shall not accept any liability
whatsoever for damage resulting from the use of e-mail. Legally
binding obligations can only arise for Centric by means of a
written instrument, signed by an authorized representative of
Centric.


Oracle LazyDBA home page