Re: Default and temp tablespaces

On Thu, 21 Apr 2005 17:45:47 +0100, "J Williams" <NOTjohnwilliams_esq_at_NOThotmail.com> wrote:

>Hi, newbie Oracle user here....
>
>Just installed Oracle 9i Release 2.on Windows XP Pro SP2.
>
>How do I determine what the default and temp tablespaces for the instance
>have been defined as?
>
>Thanks.
>

select property_name,property_value from database_properties where property_name = 'DEFAULT_TEMP_TABLESPACE'

9i can define a database default temporary tablespace, but is can't define a database default permanent tablespace. That's a 10g feature.

• Kenneth Koenraadt