Re: Multiple tablespacesI

From: Bram Mariën <bma_at_abiware.be>
Date: Mon, 22 Nov 2004 09:08:51 +0100
Message-ID: <nd73q09fidnqf1tp2ma6vnvh5b5dh0148k@4ax.com>

On Thu, 18 Nov 2004 05:19:08 -0500, "Mark C. Stock" <mcstockX_at_Xenquery .com> wrote:

>
>tablespaces are physical storage structures, not logical storage structures
>
>if you have multiple copies of identical tables, you probably want to use
>multiple schemas and then use the ALTER SESSION SET CURRENT_SCHEMA = xxxx
>command
>
>++ mcs
>

Hi,

I've done some reading, and if I understand it right, Schemas are linked to specific users.

What I want to achieve is that I got multiple datasets, where no matter which user can select the desired dataset and retreive data from the tables in that specific dataset.

I don't think schemas are meant to be used to way, or do they?

I'm sorry if I ask dumb questions, but I'm a bit overwhelmed by all the knowledge all around me !

Bram Received on Mon Nov 22 2004 - 02:08:51 CST