Re: The use of schemas

oracle dba wrote:
>
> Jim,
>
> How do you know? Yes, he wants separate tablespaces for every schema.
> I wonder if he knows he can still put tables into separate tablespaces
> without using separate schemas. :)
>
> And maybe for fun. I am going to recommend back that we use a schema
> per table!
>
> Rich

The reason for his advice (I share the general opinion on the list) may be a blue background? I have not touched DB2 for 10 years now and it may (hopefully) have totally changed now, but 'one table per tablespace' used to be something reasonable with DB2 which used to escalate locks in such a way that if many pages were locked in a table the page locks were released and the lock taken AT THE TABLESPACE LEVEL !!!

-- 
Regards,

Stephane Faroult
Oriole Ltd
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).