RE: V$DATAFILE columns

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Fri, 9 Jun 2000 11:31:36 -0700
Message-Id: <10523.108454@fatcity.com>

v$datafile and other v$ stuff are view .. u can get their definitio from the below.
you want to have a look at the view definition to get the column information

--deepAk

SQL> l
1* select VIEW_DEFINITION from v$fixed_view_definition where upper(VIEW_NAME) ='V$DATAFILE'
SQL> / VIEW_DEFINITION

select FILE# , CREATION_CHANGE# , CREATION_TIME , TS# , RFILE# , STATUS , ENABLED , CHE
CKPOINT_CHANGE# , CHECKPOINT_TIME, UNRECOVERABLE_CHANGE#, UNRECOVERABLE_TIME, LAST_CHANG
E# , LAST_TIME , OFFLINE_CHANGE# , ONLINE_CHANGE# , ONLINE_TIME , BYTES , BLOCKS , CREAT
E_BYTES , BLOCK_SIZE , NAME , PLUGGED_IN from GV$DATAFILE
where inst_id = USERENV('Insta

-----Original Message-----
From: Linda Hagedorn [mailto:Linda_at_pets.com] Sent: Thursday, June 08, 2000 1:31 PM
To: Multiple recipients of list ORACLE-L Subject: V$DATAFILE columns

Hello,

I have a database in mount, and need to rename a dataset. Will someone let me know the column name in V$DATAFILE which holds the external dataset name, and the tablespace name?

Is there a reference which lists all the V$ views, all the columns in the V$ views, and if there's a V$_view_columns (of sorts) view where I can list all the columns for a view?

Any reference to doc is sincerely appreciated.

Linda

-- 
Author: Linda Hagedorn
  INET: Linda_at_pets.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Jun 09 2000 - 13:31:36 CDT