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!

RESIZE datafile

827207Oct 17 2012 — edited Oct 18 2012

hi all,

I have a tablespace called "syscom" and it has one datafile and size is 4GB.
Now i increase 1GB to this datafile, so that the total tablespace size will be 5GB.

When i issue below coment:-

alter database datafile '/oracle/ora10g/ecms/syscom01.dbf' resize to 1GB.

tablespace size reduce by 1GB and total size is 3GB, now.

what is the query, to increase the datafile size, then.

rgds,
pravin

This post has been answered by Fran on Oct 17 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 15 2012

Added on Oct 17 2012

#general-database-discussions

9 comments

27,636 views