I have tried this on version 220.127.116.11 and 10.1.0.7 and both had similar results:
From the Schema Browser, showing Tablespaces, with Datafiles tab selected on
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
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