Re: Finding out the default tablespace

Lothar Armbrüster schrieb:
> Hello out there,
> today I was wondering how to find out the default tablespace of an Oracle
> Database. The Version is 10.2.0.4. I looked in the docs and did a bit
> googling but did not came up with a result. It seems I'm too blind too
> find the right DBA- or V$-View that holds the information.
> So the question is: how do I find out the default tablespace?
> I can create a neu user an look what its default tablespace is, but that
> is a rather clumsy method. ;-)
>
> Can you help me?
>
> Many thanks in advance,
> Lothar
>

select property_value from database_properties where property_name = 'DEFAULT_PERMANENT_TABLESPACE'

Best regards

Maxim Received on Tue Nov 25 2008 - 10:49:25 CST