select tablespace_name, file_name, autoextensible from dba_Data_files;


Kevin.

-----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