Re: tablespace question.
From: Kay Kanekowski <kay.kanekowski_at_web.de>
Date: Fri, 14 Feb 2003 21:35:45 +0100
Message-ID: <b2jjvn$1ct2pm$1_at_ID-183343.news.dfncis.de>
Date: Fri, 14 Feb 2003 21:35:45 +0100
Message-ID: <b2jjvn$1ct2pm$1_at_ID-183343.news.dfncis.de>
Hi Sybrand,
> A few other remarks
> - NEVER EVER !!!!!!!!!!!!!!!!!!!!! CREATE ANY user object in the
> SYSTEM tablespace and DON'T SET the default tablespace of ANY USER to
> SYSTEM.
tell this to Larry himself.
Or why is the default / temporary tablespace set to system, if there is no such parameter in the create-user-statement. [Quoted] The first, good step in 9i is the default_temporary_tablespace parameter in props$. But when comes the default_default_tablespace parameter ?
Kay,
who had installed his first DB2 instance last week and there thousands of
tablespaces and i don't see the sense :-(
Received on Fri Feb 14 2003 - 21:35:45 CET