Re: Finding out the default tablespace
Date: Tue, 25 Nov 2008 08:49:11 -0800 (PST)
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 Armbrüster | lothar.armbrues..._at_t-online.de
> Hauptstr. 26 |
> 65346 Eltville |
select * from database_properties where lower(property_name) like '%able%';
HTH, Steve Received on Tue Nov 25 2008 - 10:49:11 CST