Re: assigning a tablespace to a user - how?

Couldn't agree more :o)

I did actually have a bit about allocating unlimited or a value, but I deleted it in proof reading.
I don't tend to have hundreds of tablespaces, but I have about 50 instances each with about 20 user accounts max. Of these about 15 share the same 5 tablespaces (it's a partitioning thing) and the rest are individual tablespaces for the non-partitioned version of our software.

I must confess, I didn't know that there was a limit on the number of tablespaces I could have in a database - I must do a bit of experimenting - I usually have more problems with running out of datafiles :o(

Cheers,
Norman.

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com
------------------------------------------------------------------------

-----Original Message-----
From: pagesflames_at_usa.net (Dusan Bolek) [mailto:pagesflames_at_usa.net] Posted At: Wednesday, September 26, 2001 4:03 PM Posted To: server
Conversation: assigning a tablespace to a user - how? Subject: Re: assigning a tablespace to a user - how?

Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote in message news:<A43AA78C3F9DD511AAB100805FBE740D4599E6_at_lnewton.leeds.lfs.co.uk>...

/*Snipped*/
> create user myuser identified by password
> default tablespace myuser
> temporay tablespace temp
> quota 0 on system
> quota unlimited on myuser;
>
> grant unifarce to myuser;

Yes that's a good method. However I seldomly gave a special tablespace to one user, because in typical system you will easily run out of tablespaces. :-)
It's not a good idea to have hundreds of tablespaces in one database. Sometimes is good to gave one tablespace to department or division, or you can just create tablespaces users00 ... users xx, and allocate maybe tens of users to one tablespace, but that depends on application needs.
Another thing is that I very rarely gave unlimited quota to users, because user should has some limit, or you can encounter a data boom in your database.
Also is better when user encounter quota exceeded error than tablespace full, because when user exceeded his quota, then that's his fault, tablespace full is fault of DBA, because storage management is his task.

/*Snipped*/

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.