Could somebody clarify whether tablespace expansion procedure in Oracle 11g database requires any downtime or could impact availability of the database? My understanding that this can be done "on the fly" w/o downtime or restricted-mode (at least when we just allocate free space from physical disk)... but I guess there could be some exclusions caveats to this?

  • Just do autoresize=on – Mihai Feb 3 '14 at 11:22

There shouldn't be any impact adding datafiles to an existing tablespace.

Easiest is to let oracle manage the files, make sure you have DB_CREATE_FILE_DEST set:


Now the only thing to do if your existing datafiles are full or hitting the max autoextend limit is:

alter tablespace USERS add datafile;

where USERS is the name of the tablespace.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.