Re: Obtain tablespace names when database is NOT OPEN

From: <vermaat_at_gemini.tfdl.agro.nl>
Date: 1996/07/24
Message-ID: <1996Jul24.062918.525_at_ns2>#1/1


In article <4sth7j$fm7_at_mtinsc01-mgt.ops.worldnet.att.net>, Naren chintala <nchintala_at_worldnet.att.net> writes:
>Hi,
>
>Is it possible to get the names of the tablespaces of the database when
>the database is NOT OPEN. (i.e it is only mounted).

Yes, if you do a SELECT * FROM V$FILE;



| Peter J.R. Vermaat | Dutch Department of Agriculture | Wageningen |

| p.j.r.vermaat_at_fd.agro.nl | http://www.agro.nl/~vermaat/ |
|                           Flagellant in Dreamland                            |
********************************************************************************
Received on Wed Jul 24 1996 - 00:00:00 CEST

Original text of this message