Re: Finding out the default tablespace
Date: Tue, 25 Nov 2008 17:49:25 +0100
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,
select property_value from database_properties where property_name = 'DEFAULT_PERMANENT_TABLESPACE'
Maxim Received on Tue Nov 25 2008 - 10:49:25 CST