Re: Under Oracle 9, is there a guarantee of at least 1 temp TS ?

It's not random. A default was setup when the database was created. If you don't specify a default then it does indeed default to 'SYSTEM'. You can change the default with 'ALTER TABLESPACE DEFAULT TEMPORARY TABLESPACE <tablespace_name>'

http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/a90117/create.htm#1020107

Richard

Scott W wrote:
>
> My company has an installation script for our product that creates a user
> and assigns that user's temp AND default tablespace to point to the same
> tablespace (typically not an actual TEMPORARY tablespace). Now under Oracle
> 9 the TEMP tablespace MUST be a real TEMPORARY tablespace. If you just
> create a user without specifying DEFAULT and TEMPORARY tablespace, Oracle
> will pick a temp tablespace, seemingly at random. I don't have the freedom
> to delete all temp tablespaces to test my theory, so that's why I am asking:
>
> 1) Is there any guarantee that there will be at least 1 temp TS under
> Oracle 9 ? (Not that I am aware of)
>
> 2) What would happen with a create user statement with no TEMP TS clause, if
> there are no temp TSs in the instance ? Would it use SYSTEM ? Error out ?
>
> Thanks, Scott
Received on Tue May 14 2002 - 16:59:15 CDT