Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: a few basic questions

Re: a few basic questions

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Fri, 09 Jul 2004 01:18:26 GMT
Message-ID: <CnmHc.9885$Rf.6430@edtnps84>


Karl Hungus wrote:

>
> Hi All,
>
> Whats the difference between a tablespace and a schema?
>

If you consider Oracle equivalent to an operating system (valid, as it does provide a lot of the same capability), then think of tablespace as a logical volume consisting of one or more disks. You can put any number of tables (equivalent to files) in a tablespace.

A schema is a specific collection of database objects (tables, partitions, indexes, stored procedures, etc.). A schema happens to be owned by a userid. The objects that need storage resource will be stored in a tablespace.

A schema is not restricted to a single tablespace, nor is a tablespace restricted to storing info for a single schema.

> Whats the sql to list the names of tables in a ..schema? and does the user
> need any special privledges to access this information?
>

Please refer to the Oracle documentation at http://docs.oracle.com - look up the 'Oracle Reference' (not SQL, SQLPlus, ... reference) and search for the definition of DBA_TABLES, ALL_TABLES and USER_TABLES. Then continue looing for DBA_OBJECTS, DBA_TAB_COLUMNS, and others ... Received on Thu Jul 08 2004 - 20:18:26 CDT

Original text of this message

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