# Enhancement: Take over the result of the  Function "Minimum size" of datafiles into the size field

**URL:** <https://forums.toadworld.com/t/enhancement-take-over-the-result-of-the-function-minimum-size-of-datafiles-into-the-size-field/32349>\
**Category:** Toad for Oracle - Beta\
**Created:** [January 20, 2015, 12:24am UTC](https://forums.toadworld.com/t/enhancement-take-over-the-result-of-the-function-minimum-size-of-datafiles-into-the-size-field/32349 "2015-01-20T00:24:00Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![felix.neugebauer](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/felix.neugebauer/32/202_2.png) [@felix.neugebauer](https://forums.toadworld.com/u/felix.neugebauer)\
**Post date:** [January 20, 2015, 12:24am UTC](https://forums.toadworld.com/t/enhancement-take-over-the-result-of-the-function-minimum-size-of-datafiles-into-the-size-field/32349/1 "2015-01-20T00:24:00Z")

</div>

Enhancement:

I like the function “Minimum size” of datafiles.

For resizing i have to remember the result value and then i have to enter this and the dimension manually back to the fields.

I wish to have a button or function key for transfering.

And i wish choosing the dimension (MB or GB) displaying the size.

Regards

Felix

---

<div class="post-metadata">

**Author:** ![Dennis\_Paulus](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dennis_paulus/32/138_2.png) [@Dennis\_Paulus](https://forums.toadworld.com/u/Dennis_Paulus)\
**Post date:** [January 20, 2015, 5:06am UTC](https://forums.toadworld.com/t/enhancement-take-over-the-result-of-the-function-minimum-size-of-datafiles-into-the-size-field/32349/2 "2015-01-20T05:06:47Z")

</div>

Database \> Tablespaces \> [Files] tab \> Alter Tablespace \> [[Data Files] tab - Edit button.

 ![0284.pic.jpeg](https://global.discourse-cdn.com/quest/original/2X/2/274adcdbd73cfe7afe4f8ac45ef7250ea07b31b2.jpeg)

---

<div class="post-metadata">

**Author:** ![Dennis\_Paulus](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dennis_paulus/32/138_2.png) [@Dennis\_Paulus](https://forums.toadworld.com/u/Dennis_Paulus)\
**Post date:** [January 20, 2015, 5:21am UTC](https://forums.toadworld.com/t/enhancement-take-over-the-result-of-the-function-minimum-size-of-datafiles-into-the-size-field/32349/3 "2015-01-20T05:21:03Z")

</div>

Ah sorry - I see you were asking for an enhancement. Any enhancement requests like this should be added tot he Idea Pond. Thanks.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [January 20, 2015, 5:35am UTC](https://forums.toadworld.com/t/enhancement-take-over-the-result-of-the-function-minimum-size-of-datafiles-into-the-size-field/32349/4 "2015-01-20T05:35:43Z")

</div>

This feature already exists.

Go to Database -\> Administer -\> Tablespaces

Click on the “Files” tab.

Click the first toolbar button - “Calculate reclaimable MB”. This will determine the minimum space for every file in your database.

When it finishes, select the file(s) you want to shrink to that size, then click the last toolbar button “Shrink to minimum MB”.

---

<div class="post-metadata">

**Author:** ![felix.neugebauer](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/felix.neugebauer/32/202_2.png) [@felix.neugebauer](https://forums.toadworld.com/u/felix.neugebauer)\
**Post date:** [January 20, 2015, 7:12am UTC](https://forums.toadworld.com/t/enhancement-take-over-the-result-of-the-function-minimum-size-of-datafiles-into-the-size-field/32349/5 "2015-01-20T07:12:17Z")

</div>

Hallo John,

thank you very much.

You presents the solution,

which i did not know until now.

Best Regards

Felix

---

<div class="post-metadata">

**Author:** ![felix.neugebauer](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/felix.neugebauer/32/202_2.png) [@felix.neugebauer](https://forums.toadworld.com/u/felix.neugebauer)\
**Post date:** [January 23, 2015, 3:54am UTC](https://forums.toadworld.com/t/enhancement-take-over-the-result-of-the-function-minimum-size-of-datafiles-into-the-size-field/32349/6 "2015-01-23T03:54:33Z")

</div>

Hi John,

the function is fine, but very very long running on databases with some 100 files.

Using the function “shrink to minimum MB” i have to remember the returned value.

And it is a hard way to remember when controlling a lot of files.

My idea is reduction the “Calc reclaimable…” to some files

or to set the returned value of '“shrint to min …” by an confirmation to the “Datafile Size” field.

Regards

Felix

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [January 23, 2015, 7:06am UTC](https://forums.toadworld.com/t/enhancement-take-over-the-result-of-the-function-minimum-size-of-datafiles-into-the-size-field/32349/7 "2015-01-23T07:06:32Z")

</div>

Ok, the next beta will show this when you click “minimum size”. If you click Yes, the size will be applied in the dialog.

![fileshrink.jpeg](https://global.discourse-cdn.com/quest/original/2X/2/284f2701f37f94c2207c857daf3e1c60260f9885.jpeg)

---

<div class="post-metadata">

**Author:** ![felix.neugebauer](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/felix.neugebauer/32/202_2.png) [@felix.neugebauer](https://forums.toadworld.com/u/felix.neugebauer)\
**Post date:** [January 26, 2015, 12:31am UTC](https://forums.toadworld.com/t/enhancement-take-over-the-result-of-the-function-minimum-size-of-datafiles-into-the-size-field/32349/8 "2015-01-26T00:31:41Z")

</div>

Hi John,

thank you.

This very fast impementation will be very helpfull for my work.

Best Regards

Felix
