Tuesday, October 24, 2000, 6:10:24 PM, Raghav Vinjamuri wrote:
RV> Extents cannot span datafiles. Right?
RV> How about Segments? Since multiple extents make up
RV> a segment - it would be logical to assume that
RV> segments can span datafiles of a given tablespace.
Certainly, segments can span datafiles. This happens all the
time when you create a new datafile for a tablespace that is
running out of room. You can easily demonstrate it on a
test-bed database. Create a small tablespace. Create one
table in that tablespace. Fill up the table. Add a datafile.
Add more rows. Query DBA_EXTENTS.
--
Best regards,
Jonathan mailto:jonathan_at_gennick.com
Received on Fri Oct 27 2000 - 08:08:30 CDT
