Tablespaces Storage query
My oracle has a tablespace calls Maximo and contains 1 datafile Maximo.dbf (on E drive and nearly 10g in size) and its storage option is auto-extend to maximo of E drive availabiltiy.
I would like to increase this tablespace - I am thinking to add additonal oracle datafile Maximo1.dbf (on G drive) to the same tablespace.
My concern is:
"Will in event if the exisitng Maximo.dbf run out of spaces; and this new Maximo1.dbf will take over ?"
Basic info:
oracle 10g 10.2.0.1.0 (archive log enable)
OS: window 2003
Many thanks for your help.
Stan Hui