Oracle-L: RE: When was a tablespace created?

From: <Sunil_Nookala_at_Dell.com>
Date: Fri, 26 Jul 2002 09:52:00 -0800
Message-ID: <F001.004A3A92.20020726095200@fatcity.com>

try this:

select a.file_name, a.tablespace_name, b.creation_time from dba_data_files a, v$datafile b
where a.file_name = b.name

should give the time for the first file added to the tablespace, translates to
the tablespace creation time.

someone might have a better idea, I guess.

Sunil Nookala
Dell Corp.
Austin, TX

-----Original Message-----
Sent: Friday, July 26, 2002 11:30 AM
To: Multiple recipients of list ORACLE-L

Is the creation date/time for a tablespace stored within the DB? If so, where?

Charlie Mengler                                  Maintenance Warehouse  
charliem_at_mwh.com                                 10641 Scripps Summit Ct.
858-831-2229                                     San Diego, CA 92131

Lack of planning on your part doesn't constitute an emergency on my part!
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Charlie Mengler
INET: charliem_at_mwh.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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Sunil_Nookala_at_Dell.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------