RE: V$DATAFILE columns

Thank you Kristen. I'll find the manual. Regards, Linda

-----Original Message-----
From: Kristen Cameron [mailto:cameronkgd_at_inac.gc.ca] Sent: Friday, June 09, 2000 9:03 AM
To: Multiple recipients of list ORACLE-L Subject: Re: V$DATAFILE columns

I've got the page flagged in my manual. The V$ views and columns are listed in the Oracle 7 Server Reference Manual. It will be in the online docs, too. I imagine it's in the same place in the Oracle 8 documentation.

• Kristen

>>> Linda_at_pets.com 6/8/2000 >>>

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).

-- 
Author: Kristen Cameron
  INET: cameronkgd_at_inac.gc.ca

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).