Re: Default and temp tablespaces

Thanks Kenneth.

I have another couple of questions:

1. How do I determine whether the partitioning option has been installed? (Is there a way apart from reading it on the OEM Console - Instance - Configuration - General tab?)
2. How do I determine whether the partitioning option has been installed?

Thanks for any info on this.

<Kenneth Koenraadt> wrote in message
news:4267dba2.268171_at_news.inet.tele.dk...
> 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
>
>
Received on Thu Apr 21 2005 - 14:34:37 CDT