Re: Multiple Databases under Oracle

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Mon, 06 Nov 2000 05:22:56 GMT
Message-ID: <20001106.5225600@mis.configured.host>

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 11/5/00, 8:08:59 PM, Geoff Russell <geoff_at_austrics.com.au> wrote regarding Multiple Databases under Oracle:

> Hi,
 

> I'm evaluating Oracle for use with Austrics transit scheduling
> software. There are some things I want to
> do which I can't seem to do easily with Oracle. I suspect I'm trying t
 o
> do the wrong thing.
 

> I'm used to having at least one set of data for each of our clients,
> that is one data base (by which I mean
> a set of logically coherent data files). With PostgreSQL I say somethi
 ng
> like:
 

> createdb client1
> create-tables...
> createdb client2
> create-tables...
 

> I can do this for each client, the createdb statement takes under a
> second to run. I can then operate on, backup,
> etc each data base in isolation from all the other client databases.
 

> When I try to create more than one database in Oracle, it takes 10
> minutes and uses many Mb. I suspect I
> need to create 1 schema or one tablespace per client. Or is there a
> better way to do this? Basically I want
> a logically independent set of tables (the same table structure
> replicated once for each client) which I
> can work with by name, but I don't want to buy lots of new hard drives
 

> and work heaps of overtime just
> to create this set up.
 

> I hope the problem is clear. I'd appreciate being pointed in the right
 

> direction.
 

> Cheers,
> Geoff Russell

	CREATE USER client1 IDENTIFIED BY <password>
	DEFAULT TABLESPACE <tablespace name>
	TEMPORARY TABLESPACE <tablespace name>;

	If you want to keep the data physically separated create a tablespace 

for each client, but it really isn't necessary to do so. Received on Sun Nov 05 2000 - 23:22:56 CST