How is the Oracle space allocation structured?

From: Mirwais Qader <mq_at_wohl.slh.wisc.edu>
Date: 1997/04/18
Message-ID: <33579E3A.A7@wohl.slh.wisc.edu>#1/1

This is a multi-part message in MIME format.

--------------1BD17F27742A

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

I am trying to clear up some confusions about the way Oracle structures its space i.e., Database, Tablespace, OS Data files, Segments, Extents, Blocks etc...

I am still not sure how a Data file differs from a Segment.

I am also confused by OSDBA, OSOPER, SYSDBA, SYSOPER etc...

See the attached Word Document for details (if you want).

Please respond via email.
Thank you for any advice!
-Mir.

--------------1BD17F27742A

Content-Type: application/octet-stream; name="DBASTUFF.DOC"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="DBASTUFF.DOC"

<encoded_portion_removed>
cHRzAAAADU1pcndhaXMgUWFkZXINTWlyd2FpcyBRYWRlcgAAAAAAAAAAAAA=
--------------1BD17F27742A--
Received on Fri Apr 18 1997 - 00:00:00 CDT