-
I've got a datafile originally sized at 100M which has now autoextended to 130M. I have created a 2nd file in the tablespace (also of 100M and with AUTOEXTEND set to OFF).
how do I switch off the AUTOEXTEND on the 1st file?
I must be using the wrong syntax as I can't seem to do it.
-
It's Okay!
I was using ALTER TABLESPACE and not ALTER DATABASE!
My mistake. Sorry.
----------------------------
John
-
alter database datafile 'E:\ORACLE\ORADATA\NT817\INDX01.DBF' autoextend off;
-
We must've posted at the same time.
Thanks anyway, Jeff.