0

How to increase the size of table space post its max limit. if the max limit is defined as 100M and still later I need to increase it. I have written a query consisting of max size of 100M and now i want to increase it..Please let me know method for the same.

Suhel Sayyad
  • 1
  • 1

1 Answers1

0
Alter tablespace datafile 'xxx' size 200m;

Also, you can switch "autoextend on" for datafile.

Jehy
  • 4,729
  • 1
  • 38
  • 55