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

Search Discussions

  • Sunil_Nookala_at_Dell.com at Jul 26, 2002 at 5:52 pm
    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
    --------------------------------------------------------------------

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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJul 26, '02 at 4:29p
activeJul 26, '02 at 5:52p
posts2
users2
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase