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

I'm trying to resize a couple of tablespaces but the following query is only valid in Oracle 11g.

alter tablespace 2 DATAFILE '/appli2/oracle/xxx/oradata02/xxx_undo_01.dbf' resize 3g; 

In oracle v10g i try with this query, picked from oracle documentation :

alter DATABASE DATAFILE '/appli2/oracle/xxx/oradata02/xxx_undo_01.dbf' resize 3g;

I work with Oracle 10g and this query throws error message according to a non valid ALTER DATABASE modifier.

Error messages: ERROR at line 1: ORA-02140: invalid tablespace name

Thanks in advance.

share|improve this question
Is the file the only file of a bigfile tablespace? If so, I think you need to specify this using alter tablespace. – Colin 't Hart Jan 28 '14 at 12:46
Can you post the exact error in the question? – Phil Sumner Jan 28 '14 at 14:33
Yeah, i want to resize two big datafiles of the same tablespace. And the undo tablespace. – Jorge Vega Sánchez Jan 28 '14 at 14:38
up vote 1 down vote accepted

Resizing tablespaces/datafiles is not as straightforward as you might intuitively expect. The following post does an amazing job at explaining all the ins and outs, and how to do it easily through Enterprise Manager:

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.