Toad World® Forums

Bug in adding a DataFile to Tablespace


#1

I have tried this on version 9.7.2.5 and 10.1.0.7 and both had similar results:

From the Schema Browser, showing Tablespaces, with Datafiles tab selected on
RHS.

I press the button for new datafile. Select “Add Oracle Managed File” which
grays out the Datafile name. I change the Datafile size to “5” and “GB”. I make
sure that the “Auto Extend” isn’t checked.

I press Execute. Oracle creates a 100 MB datafile with AutoExtend on (which it
will allow me to modify to 5G NoAutoExtend, later, but it is not the result I
expected.)

If I press “Show SQL” instead, it says:\

ALTER TABLESPACE MAIN_INDEX ADD DATAFILE ;

It appears that the statement isn’t being built correctly.


David A. Hicken
UtahToad at gmail dot com
He who waits to do a great deal of good at once will never do anything. Life is made up of little things. True greatness consists in being great in little things.
– Samuel Johnson


#2

Thanks David. I see that too, and I’ll fix it.

As a workaround, if you open the Alter Tablespace dialog by double-clicking the
tablespace on the SB LHS, rather than the Add Datafile directly from SB, it will
work as expected.