Re: Multiple tablespacesI

"Bram Mariën" <bma_at_abiware.be> wrote in message news:posop0924ge4gcscmg4674kqiev6lhg44a_at_4ax.com...
| 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

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 Received on Thu Nov 18 2004 - 04:19:08 CST