Re: Finding out the default tablespace

On Nov 25, 11:43 am, lothar.armbrues..._at_t-online.de (Lothar Armbrüster) wrote:
> 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
>
> --
> Lothar Armbrüster  | lothar.armbrues..._at_t-online.de
> Hauptstr. 26       |
> 65346 Eltville     |

Hi Lothar,

select * from database_properties where lower(property_name) like '%able%';

HTH, Steve Received on Tue Nov 25 2008 - 10:49:11 CST