table spaces

Hello, I’m fairly new to database design and need some help
with some issues that I am facing.

Here is the problem space, the database I'm designing needs
to be able to hold multiple data sets from multiple servers.

In other words, I can log into Server#1 and save data off into
the database. And then can log into Server#2 and save data from
there. Each of the data sets from each server will be exactly the same.

There is no way of telling how many servers a user can log into. So,
the data allocation needs to be dynamic for each server up to as many
that disk space will allow.

One solution was to add a column to all the tables that the database uses to
include the location of server. Not a bad idea, but it would become a processing night
mare when queries are performed on each table. The server data can be quite
extensive for each server. I’m talking up to 50,000 – 100,000 entries.

So, I thought it would be nice to use table spaces. Each table space could represent a
server. Then I could easily use the SQL command ….

select tablespace_name, contents,status from dba_tablespaces;

to access every table space, but I have problems trying to create the same tables in different table spaces.

To make a long story short, is it possible to assign the same table to multiple table spaces?

Example, create table FooBar (pkey INTEGER NOT NULL) tablespace Server1
create table FooBar (pkey INTEGER NOT NULL) tablespace Server2
create table FooBar (pkey INTEGER NOT NULL) tablespace Server3

Is this legal?

Does the type of table space matter? Does it make a difference if it is a locally managed or dictionary?

Or do I need to create separate databases to handle the concepts discussed above?

Or I am completely off track and there is another concept that will handle this?

Thanks for your time and consideration,

Dk.

PS. Here is the stack trace I get.

java.sql.SQLException: ORA-00955: name is already used by an existing object

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAcce ss.java:2321)
at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAcc ess.java:1741)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCI DBAccess.java:1902)

at oracle.jdbc.driver.OracleStatement.executeNonQuery (OracleStatement.ja
va:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther( OracleStatement.jav
a:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStateme
nt.java:2709)
at oracle.jdbc.driver.OracleStatement.executeUpdate(O racleStatement.java
:796)
at com.raytheon.fst.managers.DBMSManager.createTables (DBMSManager.java:1
574)
at com.raytheon.fst.managers.DBMSManager.main(DBMSMan ager.java:1794)