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!

Force extend datafile

User_1VQRHJun 20 2018 — edited Jun 26 2018

I have searched the forum, internet, docs, maybe I get the question wrong or do I understand it wrong? I have no idea.

This is the theory:

1. I create a 32,000 MB datafile, starting at 1000MB, increase every 1000 MB.

2. At 5000 MB, a monitoring software says that the tablespace/datafile is less than 10% free. I know the  issues is might be with monitoring software, etc, etc, so on and so forth.

Let just say, for a long while, the data might stays at 4900 MB.

But the key question is this: Is there a command to force a datafile to extend by its original extend value? So if I call it once, the datafile will increase by 1000 MB, making it 6000. And if I call it again, it will  become 7000 (out of maximum 32,000).

Just to keep the monitoring software silent? Because by adding 2000 MB free space, the monitoring software will no longer complain.

This post has been answered by Mark D Powell on Jun 22 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2018
Added on Jun 20 2018
7 comments
673 views