Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Listeners, Instances, Ports, ...
On Tue, 14 Apr 1998 16:16:00 GMT, chuckh_at_dvol.com (Chuck Hamilton)
wrote:
>They are logical containers of data (tables or indices). Logical
>structures (tables and indices) reside in tablesapces. Tablespaces in
>turn are mapped to physical storage (i.e. datafiles) on the disk. You
>can have many tables or indices in a tablespace, and a tablespace can
>be comprised of one or many datafiles.
>
>
>Locical mytable1 mytable2 myindex1
> \ | /
> +-----------------------+
>Logical | Tablespace |
> +-----------------------+
> / \
>Physical file1 file2
Chuck,
Thanks, that's clear, mostly. It's a second-level division of physical space. Apparently it does _not_ encapsulate the names of logical structures inside.
Josh Received on Tue Apr 14 1998 - 12:16:48 CDT
![]() |
![]() |