Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
Just do autoresize=on – Mihai Feb 3 '14 at 11:22
up vote 1 down vote accepted

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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