Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: a few basic questions
"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