0

The situation is that I ran a create index query on a table (index type ctxsys.context) about 36 hours ago. The tablespace it refers to has 128gb allocated (4x32gb datafiles). As per latest situation the index is still in progress of being built however it has already taken up 100gb of the tablespace.

Would it be safe to add a new datafile to the tablespace which the index is being built? I basically want to make sure that it doesn't run out of space causing the creation to fail and leaving the index in a failed state.

Ali K
  • 3
  • 1

1 Answers1

0

It is always safe to add a data file. Me and my coworkers have done this thousands of times without any negative side-effect.

Also take a look at setting RESUMABLE_TIMEOUT. It allows statements to wait for space, instead of instantly failing.

Jon Heller
  • 34,999
  • 6
  • 74
  • 132