Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Extending smallfile tablespace

CharlovAug 10 2009 — edited Aug 10 2009

Hello,

I have a smallfile tablespace that I am trying to extend.
What I am doing is adding a file to the tablespace using the below script:
ALTER TABLESPACE TEMP_WMRK ADD TEMPFILE '/ora02/oradata/STAGEDB/TEMP_WMRK2.dbf' SIZE 512m AUTOEXTEND ON NEXT 250m MAXSIZE UNLIMITED;

Is there a way to extend the tablespace without adding a file?
Thanks..

This post has been answered by Uwehesse-Oracle on Aug 10 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 7 2009

Added on Aug 10 2009

#general-database-discussions

7 comments

3,424 views