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:
- Is there any guarantee that there will be at least 1 temp TS under
Oracle 9 ? (Not that I am aware of)
- 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 - 15:22:39 CDT
