Re: Tablespaces and multi user environment

From: Alex <alex.hudghton_at_capgemini.co.uk>
Date: Wed, 26 May 1999 08:18:30 +0100
Message-ID: <7ig78b$a4r$1@taliesin.netcom.net.uk>

No. If you think of 'schema' as another name for 'user' then this may become clearer.
Two users can have the same default tablespace, but their schemas will be separate by virtue of the fact they have different user names. They can even own tables which are identical in every way (including name), but there will be two tables existing because of the username - one will be user1.table the other user2.table.

Alex

Filip Hanik wrote in message ...
>Hi,
>I'm pretty new to Oracle and I'm trying to figure out the concept
>tablespaces and users' default tablespace.
>If two users have two different tablespaces in the same database, are they
>not sharing the same database schema?
>
>A little clarification in this matter would really help,
>
>Filip
>
>--
>Filip Hanik
>System Architect
>Digital Workforce
>fhanik_at_pacbell.net
>filip_hanik_at_hotmail.com
>415-863 7676
>
>
Received on Wed May 26 1999 - 02:18:30 CDT