This content has been marked as final. Show 3 replies
This error does not necessarily indicate whether or not you have enough space
in the tablespace, it merely indicates that Oracle could not find a large enough area of free
contiguous space in which to fit the next extent.
add datafile to your table space.
Edited by: Asad99 on Apr 1, 2013 3:59 AM
Why add a datafile when you can also resize them?1 person found this helpful
IMO this is bad advice.
Senior Oracle DBA
you are right Sybrand Bakker resize will also resolve the issue but if they have short of memory on partition level and not using lvm than adding is the only option!!1 person found this helpful
thanks for your correction.
Edited by: Asad99 on Apr 1, 2013 4:16 AM