Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to Autoextend on
- Thread starter tnerurkar
- Start date
alter database datafile 'D:\ORACLE\ORADATA\OEMREP\CWMLITE01.DBF' autoextend on maxsize 100m;
The optional "maxsize 100m" part will set a max datafile size of 100 megs. Be sure that if you set autoextend on you have enough space for all datafiles in that filesystem to expand to that size at once (unlikely but possible).
Jim
- Status
Similar threads
- Locked
- Question
- Locked
- Question