SQL> select distinct AUTOEXTENSIBLE from dba_data_files;

AUT
---
NO
YES

-----Original Message-----
From: David NGUYEN
[mailto:oracledba-ezmlmshield-x48552000.[Email address protected]
Sent: Thursday, November 30, 2006 10:18 AM
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




Oracle LazyDBA home page