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: Turkbear <john.g_at_dot.spamfree.com>
Date: Thu, 08 Jul 2004 15:36:01 -0500
Message-ID: <uobre0ho88nar57eur6q39853m3eetse8a@4ax.com>


"Karl Hungus" <nnnnndddddd_at_hotmail.com> wrote:

>
>Hi All,
>
>Whats the difference between a tablespace and a 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?
>
>..on oracle10g
>
>TIA,
>Karl

In brief ( and very brief):

Schema is the name Oracle uses for a collection of objects created by a user ( including SYS and SYSTEM) - for instance, If the user is named SCOTT then all objects he creates will be in the SCOTT schema.

A tablespace is a way to denote storage locations..Objects created in Oracle are stored in tablespaces which are defined by the DBA ( usually) to actually 'point to and use' 1 or more physical file system data files. Received on Thu Jul 08 2004 - 15:36:01 CDT

Original text of this message

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