Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 15 2012
Added on Oct 17 2012
#general-database-discussions
9 comments
23,538 views