Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Curious
Dear Oracle experts:
If I create a new tablespace with 2 or more datafiles each with autoextend on, several users are assigned to to use this tablespace, how these datafiles being used internally by oracle? i.e. which one it use first? and when it starts to use the 2nd one, and what's the logical?
Thank you very much for your expertise and Happy New Year.
![]() |
![]() |