Re: Oracle Key Concepts - Make Sure You Know All!

From: Matthias Hoys <anti_at_spam.com>
Date: Sat, 15 Sep 2007 14:34:42 +0200
Message-ID: <46ebd1d8$0$13858$ba620e4c@news.skynet.be>

> 22. Data inside the segment can reside in two or more data files with
> the same tablespace.
>
> No. A single segment does not cross file boundaries. The segments
> for a given object can span multiple data files, but a single segment,
> and the data within, resides in ONE datafile.
>

Aren't you confusing with extents ? A segment consists of one or more extents but each extent resides in only 1 datafile ? Received on Sat Sep 15 2007 - 07:34:42 CDT

This message: [ Message body ]
Next message: ken quirici: "toad and double-quoting column name"
Previous message: Nick: "Require Solution for this SQL problem"
In reply to: fitzjarrell_at_cox.net: "Re: Oracle Key Concepts - Make Sure You Know All!"
Next in thread: DA Morgan: "Re: SPAMMER Key Concepts - Make Sure You Irritate Everyone"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US