Oracle DBA

63.Can you make a Datafile auto extendible. If yes, how?
Answer

YES. A Datafile can be auto extendible.
Here's how to enable auto extend on a Datafile:
SQL>alter database datafile '/u01/app/oracle/product/10.2.0/oradata/DBSID/EXAMPLE01.DBF' autoextend on.