Hi all,
Can you increase the maxsize of a datafile? If so how? One of our datafiles is reaching the the maxsize limit. The other option is adding another datafile to the tablespace.
Thanks all,
Chucks
Printable View
Hi all,
Can you increase the maxsize of a datafile? If so how? One of our datafiles is reaching the the maxsize limit. The other option is adding another datafile to the tablespace.
Thanks all,
Chucks
alter database datafile 'foo.bar' autoextend on next 10m maxsize 2000M;
Beware of OS limits on filesize.... I have seen Windows truncate and destroy a datafile that pushed over the 4gig limit. I had to remove the tablespace and rebuild it.
Gregg