Re: Creating Database/admin questions

In article <2sl1en$o0_at_crcnis1.unl.edu>,

        nolan_at_helios.unl.edu (Michael Nolan) writes...

>Do you really need TOTALLY independent 'databases' here, or just separate
>collections of tables that will come and go as needed? Since the creation
>of a new database involves not only the allocation of disk space but also
>memory and processor resources, not to mention all the database and user
>definitions needed to actually USE data, it is not unreasonable for the
>ability to create a new database to be severely restricted.
>

Well, I'm inclined to think that under the Oracle model, totally independent databases is not feasible. I will have data files that I will need to "load" into a database - creating tables and inserting rows on the fly depending on the contents of the file. On systems where we run now, we just go out and create a new database for each datafile we format. When the user is done with the formatted data, he can just delete the database from his system.

Any suggestions on how I can achieve a similar thing with Oracle? Perhaps using tablespaces? I've just started reading up on them, but I'm not sure I could just start creating tablespaces from an application and/or size them correctly.

        marianne Received on Thu Jun 02 1994 - 13:34:08 CEST