Re: ? get tablespace name of a offline database

On 14 Aug 1996 18:55:21 -0400, xdhuang_at_paul.rutgers.edu (Xiaodong Huang) wrote:

>Hi, there
>
>Could anybody tell me if there is a way to get tablespace names
>of a offline database? I am trying to write a program that can
>list the tablespaces of a database even if it is offline.
>The server I used is Oracle 7.
>
>Thank you.
>
>X. Huang
>--
>Xiaodong Huang

Try:

select tablespace_name
from dba_tablespaces
where status='OFFLINE';

You have to be sys or system or have select privs on dba_tablespaces.

Steve Liebler [http://www.logicworks.com] Senior Product Consultant stevel_at_logicworks.com Logic Works, Inc. Phone: 609.514.2037

• Introducing ModelMart. *
• Now you can share ERwin models *
• without losing control *

  ---