Re: Creating Database/admin questions

In article <2sl67d$kfh_at_jac.zko.dec.com> anderson_at_dtracy.enet.dec.com (Marianne Anderson) writes:
>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.

You are correct in being apprehensive about programmatically sizing tablespaces. We have a database administrator and from taking with her I have gleened that creating tablespaces, sizing tables and indexes is as much art as it is science. If you have the disk capacity to burn you can users the privilege to create and drop space-requiring objects (i.e. tables & indexes) and allow the dba to clean up after them, but our dba gets very nervous with that idea.

-- 
============================================================================
Michael Sallwasser  | Down one path is utter dispair and hopelessness. Down 
Long Beach CA       | the other is total destruction. Let us choose wisely.
============================================================================