Multiple tablespacesI

Hello,

I'm new to this list, but I've read through a lot of messages / url's / school handbooks, but can't find to seem an answer to an idea I've got.

I'm developing an application that should run on SQL Server, MySQL and Oracle.
In this application, I want to store users and userprofiles etc, and 'normal' data.

I've thought about an architecture, where I want to seperate the user-information (username, password,telephone, email etc) from the actual data, so x amount of data-tablespaces can be used (think about DEMO-data, archivedata and actual data). Each of these tablespaces contains the identical tables.

I've figuered a way to achieve this in SQL Server & MySQL, but now I'm investigating wether this can be done using Oracle.

Basically, this would mean that I should have >1 tablespaces. My idea was that during login in the application, the user could choose which data he/she wants to use (either the actual dataset or the demo dataset or ...)

In SQL Server, I would create multiple databases, where I can use the command 'USE <<DATABASENAME>>' to select the wanted database.

I understand the basics of the Oracle structure, but how can I choose the wanted tablespace?

Thanks in advance for any hints/tips/explanations !

Bram Received on Thu Nov 18 2004 - 04:11:11 CST