multiple datafiles with autoextend
From: Vissu <vissuyk_at_yahoo.com>
Date: 2 Dec 2002 19:02:14 -0800
Message-ID: <2bedd6a7.0212021902.7ebe0ec3_at_posting.google.com>
Date: 2 Dec 2002 19:02:14 -0800
Message-ID: <2bedd6a7.0212021902.7ebe0ec3_at_posting.google.com>
Hi,
I noticed that a datafile created with AUTOEXTEND ON has been extended
by the database. But then I've added a new datafile to the tablespace.
Will Oracle use the newly added datafile or will it keep on extending
the old one. Both files have autoextend on.
Thanks for any help
Vissu