Skip to Main Content

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 15 2012
Added on Oct 17 2012
9 comments
27,622 views