Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> When a table was created?

When a table was created?

From: Geoff May <Geoff.May_at_doka.de>
Date: Tue, 14 Aug 2001 16:40:15 +0200
Message-ID: <3b7938c1$0$237$4dbef881@businessnews.de.uu.net>

Hello all,

Does ORACLE store a time stamp when a table was created and/or altered?

For example, I'd like to do something like:

SELECT CREATE_TIMESTAMP, MODIFIED_TIMESTAMP FROM SOME_SYSTEM_TABLE
WHERE TABLE_NAME LIKE '%XYZ%' MfG

Geoff.

--

"Sage nicht immer, was du weißt, aber wisse immer, was du sagst." - Matthias
Claudius
"If you haven't got anything to say, don't say it." - My mother.
Received on Tue Aug 14 2001 - 09:40:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US