Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> When a table was created?
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.
--Received on Tue Aug 14 2001 - 09:40:15 CDT
"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.
![]() |
![]() |